2 columns in table:
one column :unit no. (i.e 34243) and the second : corresponding distance data (i.e 1.1767).
To write for each distace range (0-1, 1.5-2) how many units there are in that range.
What query do i have to use in the expression editor?
thanks in advance!
I.e. you use a calculated dimension.
can you help me with syntax of class? for example if i want between the range 1-1.5 miles
If you want each half mile, and the Distance field is in units of Miles, then
you gave me this solution and it worked:
Now instead of Distance data I created calc dimension which called CalcDist, in Qlik sense
But if Now I change the name of the field in the command:
it says it is bad field name..
Try like this in script
If(distance > 1.5 AND distance <=2, '1.5-2',
If(distance >0 AND distance <= 1, '0-1', 'Other')) AS Range
Now in just use this
Hope this helps you.
Retrieving data ...