Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 

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

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. 

Labels (3)
2 Replies

Don't get the correct solution as of now.