topic Re: sort order in QlikView

sort order

gauthamchilled — Fri, 30 Oct 2015 04:08:22 GMT

I have 2 dimensions and 1 expression in a stacked bar chart.

1st dimensions is calculated one and the second one is direct dimension.

can I sort using the second dimension, if so how. can you help me

Gautham.

prma7799 — Fri, 30 Oct 2015 04:11:20 GMT

Hi Gautam,

Yes you can sort.

Can you share some sample file...

Thanks

avinashelite — Fri, 30 Oct 2015 04:19:33 GMT

Hi Gautham,

Yes, you can sort . Go to Chart properties>Sort>expression> add suitable sort expression according to the calculated dimension

Hope this helps you

jsingh71 — Fri, 30 Oct 2015 04:20:03 GMT

Yes you will do. Go to Sort tab and provide the condition over there.

sujeetsingh — Fri, 30 Oct 2015 04:36:41 GMT

At sort properties try promoting the second one

jagan — Fri, 30 Oct 2015 05:54:58 GMT

Hi Gautam,

Try like this

Properties -> Sort-> Select Calculated Dimension -> and give second dimension in Expression tab.

Regards,

Jagan.

gautik92 — Fri, 30 Oct 2015 05:57:25 GMT

sort tab->select the second dimension and sort it accordingly

nagarjuna_kotha — Fri, 30 Oct 2015 06:04:14 GMT

Share Some sample data .in which way u want..

Fri, 30 Oct 2015 07:22:18 GMT

Hello,

I'd think you'd also need to uncheck all sort options for dimension 1, otherwise it will be ordered by these sort checks first.