Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator 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

6 Replies
er_mohit
Master II
Master II

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
Specialist
Specialist

Go to sort tab,

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

Not applicable

hi

sorting at script label:
     order By name  asc ;

or

object iproperties

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


QSense
Creator II
Creator II
Author

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
Master II
Master II

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
Creator II
Creator II
Author

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