Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

sort in stacked bar

hi all,

how to sort the stacked bar as per the value

below is the data

dept           student

IT                100

CSE             200

Robotics          300

CSE               500

Robotics          50

robotics          150

now when i used dimension as Dept and calcualted dimension as 1 and student count as expression i m getting the output , but values are  not sorted even when i used sorting from low to high

how to do that, please help me

25 Replies
manoranjan_d
Specialist
Specialist
Author

no reply

nagaiank
Specialist III
Specialist III

If you define your calculated dimension as the first dimension, dept as second dimension with sort order by expression sum(student) descending and sum(student) as expression, you will be able to get a stacked bar chart with the desired sorting.Capture.PNG

manoranjan_d
Specialist
Specialist
Author

can you pls send me the file or attach the file

gautik92
Specialist III
Specialist III

Have a look at this

manoranjan_d
Specialist
Specialist
Author

i cant see ur file

gautik92
Specialist III
Specialist III

are yu using personal edition

manoranjan_d
Specialist
Specialist
Author

if i use one dimesnion i m losing my  stac bar option in style, so i added calculated dimension as 1 and y-axis i did result is not coming

manoranjan_d
Specialist
Specialist
Author

no, file s not attached when u said look at this

gautik92
Specialist III
Specialist III

i can see the file attached

any way