#23 🗺️ Non directional dimension in Qlik Sense

🗺️ Guess know who is your best friends when you are playing with origins and destination?

I'm actually playing with freight data and doing a "From-To" analysis is quite a basic one.
I can easily find value for From A to B and then From B to A. But what if I want to find A to B and B to A?

Yes, create a Non-Directional Dimension!

Please welcome our friends RangeMinString and RangeMax String() ! 🧙‍♂️

Did you already have to deal with this kind of data? What are your tips ?

❓How To❓

My sample Data is structured like this :
"State From", "State To", Value
IA, MA,125
MA,IA,478

In the Script I add a field to my load statement by doing :
RangeMinstring ("State From","State To")
&'-'&RangeMaxstring ("State From","State To")
as "Non-Directional Origin to Destination",

Quite Handy no?