Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Preserve pivot table after selection in Qlik Sense

I have a requirement to produce a Pivot table in Qlik sense which does not collapse when you click on one of the cells. Basically, we don't want the pivot to change when you filter on one of the dimensions within the table object. We can only click on dimensions or if it is possible to click on measures but all the other columns stay the same.



7 Replies
Not applicable

Re: Preserve pivot table after selection in Qlik Sense

by using this expression   sum({<product=>}sales) I achieve my goal but another problem is, how to show zero in all other cells accept selected one??


Thanks

MVP
MVP

Re: Preserve pivot table after selection in Qlik Sense

So you want the expression to show 0's for whatever isn't selected?

May be try this:

Sum(sales) + Sum({1} 0)

Not applicable

Re: Preserve pivot table after selection in Qlik Sense

Hi sunny

Thanks for reply but its not working, I'm not getting zeros, as my expression is count({<product=>}ID) + Sum({1} 0)  any help will be appreciated. If you need attachment I'll put it.

Thanks

MVP
MVP

Re: Preserve pivot table after selection in Qlik Sense

Yes, attachment would be helpful.

Not applicable

Re: Preserve pivot table after selection in Qlik Sense

Sorry forgot There  is attachment on the top, its Pivot table but show one value selected and all other cells should show Zero's.

Thanks

Not applicable

Re: Preserve pivot table after selection in Qlik Sense

Thanks

Not applicable

Re: Preserve pivot table after selection in Qlik Sense

Hi Everyone

This expression was working but some filters collapse the columns and rows and instead of 5 shows 3 or 4, by using this expression sum({<product=>}sales),

Any guidance will be appreciated

Thanks

Community Browser