Discussion Board for collaboration on QlikView Scripting.
Below table shows the source and destination information. I would want to count the no. of instances of travel between 2 cities.
The desired answer is:
US - Canada = 3
US - Denmark = 2
US - UK = 1
US - Brazil = 1
Source and Destination as Dimension
Count(distinct Destination) as Expression
Maybe like this
If(Source precedes Destination, Source & '-' & Destination,Destination &'-'&Source) as Travel
Then create a chart with dimension Travel and expression
This is amazing
I guess the MaxString() or MinString() can also work here, right?
UPDATE: RangeMaxString() or RangeMinString()
UPDATE2: Something like this:
RangeMaxString(Source, Destination) & '-' & RangeMinString(Destination, Source) as Travel;
LOAD * Inline [