topic Re: sort in stacked bar in QlikView

sort in stacked bar

manoranjan_d — Thu, 15 Oct 2015 20:46:38 GMT

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

Re: sort in stacked bar

manoranjan_d — Thu, 15 Oct 2015 22:05:17 GMT

no reply

Re: sort in stacked bar

nagaiank — Fri, 16 Oct 2015 01:02:29 GMT

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.

Re: sort in stacked bar

manoranjan_d — Fri, 16 Oct 2015 06:22:18 GMT

can you pls send me the file or attach the file

Re: sort in stacked bar

gautik92 — Fri, 16 Oct 2015 06:40:21 GMT

Have a look at this

Re: sort in stacked bar

manoranjan_d — Fri, 16 Oct 2015 06:44:00 GMT

i cant see ur file

Re: sort in stacked bar

gautik92 — Fri, 16 Oct 2015 06:44:57 GMT

are yu using personal edition

Re: sort in stacked bar

manoranjan_d — Fri, 16 Oct 2015 06:45:05 GMT

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

Re: sort in stacked bar

manoranjan_d — Fri, 16 Oct 2015 06:46:39 GMT

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

Re: sort in stacked bar

gautik92 — Fri, 16 Oct 2015 06:48:31 GMT

i can see the file attached

any way

Re: sort in stacked bar

manoranjan_d — Fri, 16 Oct 2015 06:49:40 GMT

Re: sort in stacked bar

gautik92 — Fri, 16 Oct 2015 06:50:43 GMT

i hope it wont help you i misuds your req

Re: sort in stacked bar

manoranjan_d — Fri, 16 Oct 2015 06:52:01 GMT

hi naga,

i m getting the output thanks, when i m using the expression as ascending or descending in sort tab, but in case if we are using two expression means how to do that ?

Re: sort in stacked bar

manoranjan_d — Fri, 16 Oct 2015 07:01:42 GMT

hi NagaianK

i m waiting for ur reply, how to do the same sort in the stack bar bar for two expression.

Re: sort in stacked bar

gautik92 — Fri, 16 Oct 2015 07:10:09 GMT

This one

Re: sort in stacked bar

manoranjan_d — Fri, 16 Oct 2015 07:11:45 GMT

Hi gwtham,

can u send me the file to my mail id maoranjan321988@yahoo.com, bcoz i cant see ur file

Re: sort in stacked bar

gautik92 — Fri, 16 Oct 2015 07:13:09 GMT

what is the second expression

Re: sort in stacked bar

gautik92 — Fri, 16 Oct 2015 07:15:14 GMT

i don have email access sry

ill tel the steps to do

first dimesion =valuelist('1')

second dimesion=dept

expr=sum(student)

sort=select dept->by expr->sum(sales) by desc

style stacked

Re: sort in stacked bar

manoranjan_d — Fri, 16 Oct 2015 07:16:02 GMT

i can see your file

Re: sort in stacked bar

manoranjan_d — Fri, 16 Oct 2015 07:18:16 GMT

gowtham u have to give sort expresiion only on dept, not on the both, just now checked it, then only assending or descending is happening, so remove the sort expression in the value list a