Discussion Board for collaboration related to Creating Analytics for QlikView.
I have created a calculated dimension and ı wanna sort data according to this expression
500-1000 points (these are results of dimension)
in right click on your sheet object in properties--> sort tab there you check the numeric value asccending order
either you can sorting the value in script level.. for this you have load your table then the use group by function for sorting purpose
hope it helps
Go to sort tab,
Select ur caluculated dimension and use sort options based on requirement.
sorting at script label: order By name asc ;
sort tab --->check numeric value in asccending order
Thanks for replies ,
but it didnt work maybe if I give dimension
Could you give alternative solution?
if(Field>0 and Field<=500,'0-500 point,if(Field>500 and Field_PUAN
<=1000,'500-1000 point, ))
in dimension tab set your field as
here vRange is variable that assigned to max value for one axis
like if yo want to display data with 2 values that set it to 500
or either in splitting form then set to 100
then range become 0<=n<100,100<=n<200..........1000
Thanks After I try , I will share ur solution is proper or not for my case:)