topic Sort with Multiple dimesnion in QlikView

Sort with Multiple dimesnion

Anonymous — Wed, 18 Feb 2015 15:01:39 GMT

i have pivot table with one dimension and some expression. i want to sort my table dimension in Sort expression with other two fields(dimension) in my table. for example first i want sort with year and then month. i have only one dimension in pivot table.

In Qlikvew i tried with Sort Expression i have given =Year,Month (but it is showing error)

Please suggest me how to fix this

regards

ramu

Re: Sort with Multiple dimesnion

jyothish8807 — Wed, 18 Feb 2015 15:17:21 GMT

Hi Ramu,

Its little confusing what you have mentioned. How many dimensions you have? And what are they?

Regards

Re: Sort with Multiple dimesnion

jyothish8807 — Wed, 18 Feb 2015 15:26:06 GMT

Sorting of multiple dimensions doesn't work in pivot, try the same with straight chart.

Regards

Re: Sort with Multiple dimesnion

Anonymous — Thu, 19 Feb 2015 06:35:36 GMT

Hi Jyothish

I have straight table t as below then I want sort YrMonth (dimension) first with year and then month

I want something as below

Mar-FY14

Jun-FY14,

Sep-FY14

Nov-FY15

Dec-FY15.

Please help me to how to fix this.

Re: Sort with Multiple dimesnion

Anonymous — Thu, 19 Feb 2015 06:44:22 GMT

Can you share a sample application

Re: Sort with Multiple dimesnion

Anonymous — Thu, 19 Feb 2015 06:59:31 GMT

Hi ,

Find attached solution,

You can also use master calendar.

Let me know if you are looking for the same or not.