Pivot table - manually collapse and collapse all

[#1]

Hi,

I have a question regarding the collapse all function for pivot tables:

If I collapse all FY manually, the result is different than to the result from collapse all function.

After clicking on collapse all, values are shown (which are correct) but not visible, when I collapse manually.

On top, I use 3 dimensions, the first one is synthetic dimension (using Valuelist('FY', 'YoY')), the second is FY and the third one is FQ.

I don't know why that happens..I noticed that the FQ dimension is also collapsed when I use "collapse all".

Result after collapsing manually:

Result after using "collapse all" function:

Thanks!

Kind regards,

Simone

[MK_QSL]

Dear Simone,

If you upload your sample file would be helpful to all to get the desired result.

[#3]

Please find attached the sample file.

[#4]

If I may ask, why would you want to show this like that? Since you have a pivot table and all Fiscal Years will be included if none are excluded, then why show a YoY field. It is quite obvious to the EU that if they are looking at 2014, that 2013 is the previous years result?

My question is always this when deciding what to show; what value is adding this functionality or view going to add? If you can maybe shed more light as to why you want to show this or what you are trying to achieve, then maybe we can come up with a better view

Regarding your original query though, it would be easier to do this I believe

1) create an inline load with 'Fiscal Year','Last Year' and call it comparison for example

2) when you add fiscal year in after comparison, simple use an if statement to do this, if(Comparison = 'Last Year',FiscalYear-1,FiscalYear

3) in your expression you know longer need to use valuelist or a before(sum()) statement, you can simply sum

Thanks,

Byron Van Wyk

QlikVieW & Other Ramblings

[#5]

Hi Byron,

thanks for your response. Actually, I don't want to show the previous value in YoY but calculate the deviation of the values of actual and previous year (and on quarter level deviation between quarter values).

Kind regards,

Simone