Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

QSense
Contributor II

sort data based on calculated dimension

Hello everyone,

I have created a calculated dimension and ı wanna sort data according to this expression

my example

0-500 points

500-1000 points (these are results of dimension)

Thanks

Tags (2)
6 Replies
er_mohit
Honored Contributor II

Re: sort data based on calculated dimension

hiiiii

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

khadeer_sparks
Valued Contributor

Re: sort data based on calculated dimension

Go to sort tab,

Select ur caluculated dimension and use sort options based on requirement.

Not applicable

Re: sort data based on calculated dimension

hi

sorting at script label:
     order By name  asc ;

or

object iproperties

sort tab --->check numeric value  in asccending order


QSense
Contributor II

Re: sort data based on calculated dimension

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, ))

Thanks

er_mohit
Honored Contributor II

Re: sort data based on calculated dimension

in dimension tab set your field as

=class(aggr(Sum(Field),Field_PAUN),vRange, 'n')

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

QSense
Contributor II

Re: sort data based on calculated dimension

Thanks After I try , I will share ur solution is proper or not for my case:)