Preserve pivot table after selection in Qlik Sense

[#1]

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.

[#2]

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

[sunny_talwar]

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

May be try this:

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

[#4]

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

[sunny_talwar]

Yes, attachment would be helpful.

[#6]

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

[#7]

Thanks

[#8]

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