topic Re: stack bar sort for two expression in QlikView

stack bar sort for two expression

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

hi all,

below is my data

Date	student male	student female
10/16/2015	a	a
10/16/2015	a	a
10/16/2015	a	a
10/16/2015	a	a
10/16/2015	a	a
10/16/2015	a	a
10/16/2015	a	p
10/16/2015	a	p
10/16/2015	a	p
10/16/2015	a	p
10/16/2015	a	p
10/16/2015	a	p
10/16/2015	a	p
10/16/2015	a	p
10/16/2015	p	p
10/16/2015	p	p
10/16/2015	p	p

now i want stack bar so i used the first dimension as calculated dimension as 1 and second dimension as date to get the stack bar and then in expression , first expression as count of ({<student male={p}>}date) and second expression i used count of ({<student male={p}>}date)

now i want these count to be sorted in low to high in the stack bar, in sort option how to do sort for two these two expression.

Re: stack bar sort for two expression

manoranjan_d — Fri, 16 Oct 2015 09:15:11 GMT

no reply

Re: stack bar sort for two expression

miguelbraga — Fri, 16 Oct 2015 09:18:57 GMT

Hi Manoranjan

Can you please send us a sample .qvw?

Thanks,

Miguel

Re: stack bar sort for two expression

manoranjan_d — Fri, 16 Oct 2015 09:34:56 GMT

u can create qvw file on this data and make a review

Re: stack bar sort for two expression

miguelbraga — Fri, 16 Oct 2015 09:40:29 GMT

Here Manoranjan, see the attached file.

Is this what you're looking for?

Re: stack bar sort for two expression

manoranjan_d — Fri, 16 Oct 2015 09:45:20 GMT

when i seen ur file the sort is happening, pls check the sort tab and test yourself the ascending and descending order its not changing

Re: stack bar sort for two expression

manoranjan_d — Fri, 16 Oct 2015 09:48:19 GMT

sorry sort is not happening in ur file pls check

Re: stack bar sort for two expression

miguelbraga — Fri, 16 Oct 2015 09:51:30 GMT

That's because it's a stacked bar chart, the first expression goes to bottom of the chart, the second above, the third above the second, etc... Change the order of expressions and you'll see the change

Re: stack bar sort for two expression

manoranjan_d — Fri, 16 Oct 2015 13:17:15 GMT

ok but this is not the correct answer becuase if the first expression is high it go down in the chart, the chart shpuld manually arrange the sort as per the sort tab we given