topic Re: Pivot table - Expression visibility in QlikView

Pivot table - Expression visibility

googel84 — Fri, 22 Jul 2016 13:49:49 GMT

Hi, I created a pivot table that has some dimensions vertical-wise and two dimensions horizontal-wise.

The target is to hide Fatt. (pz) only when Anno is 2011 and Mese is 'dic'.

I don't think it is feasable, to be honest, as I think you can only govern the expression overall visibility.

Any ideas?

Thanks

Re: Pivot table - Expression visibility

vishsaggi — Fri, 22 Jul 2016 14:13:44 GMT

Hi Alberto,

Could it be possible to share some sample application here ??

In expression tab you have a conditional check box to give a condition for that specific expression field. Need little more information on this.

Thanks,
V.

Re: Pivot table - Expression visibility

deec — Fri, 22 Jul 2016 14:28:17 GMT

set analysis Operators

Sum({$ - $<Anno={2011}> * $<Mese={'dlc'}>} Amount)

That should give you everything except the intersection of 2011 and dlc. If you added parenthesis it would look like this: but they're not needed because of order of operations on Set operators.

Sum({$ - ($<Anno={2011}> * $<Mese={'dlc'}>)} Amount)

Re: Pivot table - Expression visibility

googel84 — Fri, 22 Jul 2016 14:40:32 GMT

Hi, thanks for your reply. For some reasons I cannot reply and attach at the same time, even with advanced editor...

I was already aware of the Enable option and relevant condition and it does not represent a solution to the problem as it lets you define a condition to enable or disable your expression as a whole. I mean, it lets you hide Fatt. (pz) from the whole pivot table, not from only a portion of it.

Thanks anyway.

Re: Pivot table - Expression visibility

vishsaggi — Fri, 22 Jul 2016 15:13:13 GMT

Try this.

Re: Pivot table - Expression visibility

vishsaggi — Fri, 22 Jul 2016 17:05:53 GMT

Hello Alberto,

Did you try that, did it solve your issue?

Re: Pivot table - Expression visibility

vinieme12 — Fri, 22 Jul 2016 18:20:51 GMT

I don't think suppressing an expression for a particular dimension value is possible.

Re: Pivot table - Expression visibility

googel84 — Mon, 25 Jul 2016 10:30:29 GMT

No, this way you are hiding Fatt. (pz) (every occurrence of it) when only dic-2011 is available.

This is not the target.

Re: Pivot table - Expression visibility

vinieme12 — Mon, 25 Jul 2016 11:19:54 GMT

This is not possible in a Pivot table

Re: Pivot table - Expression visibility

deec — Mon, 25 Jul 2016 15:35:13 GMT

Alberto, did this end up working for you? It worked for me on first try.

The original chart had many Anno and Mese values shown in a pivot

After using that set analysis on the expression, no values are returned for the intersection of 2011 and dlc, so that expression is hidden ONLY in that intersection.

hidden is not really the right word... it's just not there because the expression is set to ignore all the values.

Re: Pivot table - Expression visibility

deec — Tue, 26 Jul 2016 12:55:59 GMT

If you know the values of the dimensions you are trying to "hide" from any kind of chart (pivot table included), you can do so through set analysis.

Is the answer I posted earlier on this thread not working for you? Would it help if I upload a sample qvw?