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!
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.
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..