Sort with Multiple dimesnion

[Anonymous]

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

[jyothish8807]

Hi Ramu,

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

Regards

KC

[jyothish8807]

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

Regards

KC

[Anonymous]

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.

[Anonymous]

Can you share a sample application

[Anonymous]

Hi ,

Find attached solution,

You can also use master calendar.

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