QS: Pivot table should display rows for these areas selected in a filter and it should not display rows for the remaining areas

Anuhyak1 — Fri, 15 Nov 2024 21:09:23 GMT

I have Area filter which displays values ( CA, GA, NA).

I have National and Area view button 0 is national and 1 is Area and the variable tNationalRegion is set to 0.

I have the pivot table changing between National and Area view. In the Area view the dimensions are Area, Measure Group and measure. Here are the expressions for Previous Report Year.

if ($(tNationalRegion) = 0,

If(Dimensionality()<=1+$(tNationalRegion), '',

Only({<Flg_Fact={'Dashboard'}, [Fac Area Name]=, [CRS Version] = {'$(vCRS_VER)'},Flg_National={$(=$(tNationalRegion))}>} [Previous Report Year Target])),

If(Dimensionality()<=1+$(tNationalRegion), '', Only({<Flg_National={$(tNationalRegion)}>} [Previous Report Year Target]) )).

When we select Areas from filter ( CA, GA, NA) the pivot table should display rows for these areas selected and it should not display rows for the remaining areas which are null . Please help me with the expressions. Attached excel for your reference.

Re: QS: Pivot table should display rows for these areas selected in a filter and it should not display rows for the remaining areas

Or — Tue, 26 Dec 2023 14:39:21 GMT

Looks like a double-post of this:

https://community.qlik.com/t5/New-to-Qlik-Sense/Filter-rows-in-Pivot-table-based-on-Areas-selected-in-a-filter/m-p/2156090#M243313

Re: QS: Pivot table should display rows for these areas selected in a filter and it should not display rows for the remaining areas

Anuhyak1 — Tue, 26 Dec 2023 15:01:31 GMT

Don't get the correct solution as of now.

topic Re: QS: Pivot table should display rows for these areas selected in a filter and it should not display rows for the remaining areas in App Development

QS: Pivot table should display rows for these areas selected in a filter and it should not display rows for the remaining areas

Re: QS: Pivot table should display rows for these areas selected in a filter and it should not display rows for the remaining areas

Re: QS: Pivot table should display rows for these areas selected in a filter and it should not display rows for the remaining areas