topic Pivot table requirement in QlikView

Pivot table requirement

kishorj1982 — Tue, 24 Oct 2017 05:04:52 GMT

Hi All,

For one of the expression , I need to show only subtotals not the other values in pivot table column.

Is it possible.

Thanks

tresB — Tue, 24 Oct 2017 05:13:23 GMT

Try like:

Expression: If( dimensionality()=0, <Your Expression>)

Expression: If( Secondarydimensionality()=0, <Your Expression>)

kishorj1982 — Tue, 24 Oct 2017 05:54:58 GMT

Hi Tresco,

Thanks for the response,

Can you please tell me how to show expression values at 2 dimensionality levels.

I need to, show subtotal at dimensionality level 0 and 3.

Thanks

tresB — Tue, 24 Oct 2017 05:59:28 GMT

May be like:

If( dimensionality()=0 OR dimensionality()=3, <Your Expression>)