Qlikview Pivot Table - Selectively Show Calculation

jono19872002 — Thu, 11 Nov 2021 09:12:40 GMT

If i have a simple pviot as per below with the person field as a column and the category field dragged across the top so it goes accross.

I also have several expressions, is there a clever way of for example hiding the "count" expression for a specific Category, I guess i could manually formulate in a straight table each combination but i would rather keep dynamic by using a crosstab like pivot. But as not all the expressions are relevant for each category i was hoping there is a way i could hide them somehow?

Re: Qlikview Pivot Table - Selectively Show Calculation

Or — Thu, 11 Nov 2021 09:44:16 GMT

As far as I know, there's no way to exclude an expression from displaying for all dimension values. You could modify the way the expression behaves within each category e.g. if(Category=1,Something,SomethingElse) but not hide the column entirely.

topic Qlikview Pivot Table - Selectively Show Calculation in QlikView

Qlikview Pivot Table - Selectively Show Calculation

Re: Qlikview Pivot Table - Selectively Show Calculation