Problem sort order with set analysis

[#1]

Hi all,

i need some help about the order of a table.

I have a pivot table with months as dimensions and various expressions.

This months have to be ordered from july to june, in order to view a whole fiscal year.

(pic attached)

For doing this, I have created a table like this:

LOAD * INLINE [

    Month, Sort

    07, 1

    08, 2

    09, 3

    10, 4

    11, 5

    12, 6

    01, 7

    02, 8

    03, 9

    04, 10

    05, 11

    06, 12];

then I add "Sort" in the Properties -> Sort -> Expression.

Up to here, no problems.

But, if i add a particular selection in the set analysis of one or more expressions  - something like this

sum({$< Customer= >} Invoices.materialcqty

the sorting applied before doesn't work anymore.

Any hints?

Thanks, regards

Federica

[#2 · Accepted solution]

Have you entered an equal sign before Sort in the sort expression?

=Sort

If that doesn't work, if you can, change the pivot to a straight table, add Sort as a dimension.

Under the Presentation sheet in properties. Press the check box for hiding the Sort dimension.

The Sort dimension can still be used in the Sort sheet in the properties window.

BR, Per Wagner

[#3]

When i add the equal sign, it still doesn't work.

With the second method it works fine.

But there isn't a way to hide a column in the pivot table? For this report i prefer to use this one.

Thanks,

Federica

[#4]

No, unfortunately there is not any hide column feature in the pivot table.

Is the "Month" field in the same format in the Sort Table as in the Data Table?

07, 08, etc.

Depending on what source your have for your data, sometimes QlikView reformats it.

07 becomes 7. This can be solved by putting Text(Month) as Month in the load script.

BR Per.