topic Re: '=<' in a Pivot table dimension in QlikView

'=<' in a Pivot table dimension

Thu, 06 Nov 2014 09:36:02 GMT

Hi,

I have a pivot table which has month as a column dimension.

'Month' is also a field in the document so when I choose September, for example, the table has only one column headed 'September'.

How could I make the pivot table to show columns for all months from january to the selected month?

Thanks

Re: '=<' in a Pivot table dimension

simondachstr — Thu, 06 Nov 2014 09:42:15 GMT

Using set analysis could solve your issue. To help you with that you'll need to give us your expression & dimension field.

Another question.. do you only load month or is there also a year field? This might affect the expression.

Re: '=<' in a Pivot table dimension

maleksafa — Thu, 06 Nov 2014 09:55:59 GMT

in your expressions you need to ignore the month selection, like sum({<Month=>} Sales), this expression will return the sum sales ignoring your month selection, now from this expression you can create what you want, if it is incremental or not.

Re: '=<' in a Pivot table dimension

simondachstr — Thu, 06 Nov 2014 09:57:08 GMT

Malek, it is a requirement that all months up to the selected month should be displayed. Ignoring the month selection is not going to work.