topic Re: Pivot Table : conditionally showing expression in QlikView

Pivot Table : conditionally showing expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a pivot table with 4 dimension and 6 expressions, I want to conditionally show metrics\expressions under the dimension. So in below screenshot all metrics are visible, but the requirement is to show Metric 1 for Category as H and L while Metric 2 when category in only L while Metric 4 should be visible only when Category is L and M.

I tried conditional in expressions tab its not working .

Re: Pivot Table : conditionally showing expression

swuehl — Thu, 14 Sep 2017 21:11:38 GMT

The conditional on expression tab works globally for the chart, not per (any) dimensional value.

The only solution I can see is creating an artificial dimension that is linked to certain dimensional value combinations only, and then create a single expression that branches into several expressions based on that artificial dimension value.

There are some examples here in the forum how you can do that.

Re: Pivot Table : conditionally showing expression

dinuwanbr — Fri, 15 Sep 2017 07:31:37 GMT

Hi Sanketh,

I'm still working on your sample. But up to now how about something like this,

1. Create 3 charts on top one another and use Category in the set analysis expression. (For category H there will e only expressions you need, for other categories as well)

2. Set the visibility and movability based on your selection to make it working fine.

Rgds,

Tharindu

Re: Pivot Table : conditionally showing expression

andrei_delta — Sun, 17 Sep 2017 10:43:56 GMT

Hello,

I tried something and...hope this is what you are looking for. I can't figure out how to put the app here but i'll put the code.

For metric 1, click conditional : if(match(GetFieldSelections(Category),'H, L'),1,0);

For metric 2, click conditional: Category='L';

For metric 4, click conditional : if(match(GetFieldSelections(Category),'L, M'),1,0) .

Hope it helps!

Thanks,

Andrei