I am not from Qlik and I don't know how the logic is defined. It looks by default in pivot table if the value is 0, it will be shown. Here is my workaround for your questions:
1. Change Dimension to
if(aggr(sum([Sales Amount]), Customer, [Product Line])>0, Customer)
and uncheck "show null values".
2. Change Only to Max.
3. Not sure what you mean because I don't see customer "A-2-Z solutions" is hidden? Which object are you talking about?
Hi, thank you for taking your time to answer my question. I appreciate it.
1. I think your answer "1" refers to the top-left pivot table. Yes, I believe by creating a "calculated dimension" you can hide the other customers. However, I still don't understand when I need to do this, because if there wasn't a productline dimension, qlik will just hide it without the walkaround.
3. "A-2-Z solutions" is hidden in the SECOND pic. Why doesn't qlik just show 0 (like your answer in "1"), instead of completing hiding that dimensional value.
I guess I'm looking for a more consistent answer that explains the mechanics or reasoning regarding when qliksense decides to:
* show the dimensional value but show "0" as measure.
* hide the entire row
* show the "-" for both dimensional value and measure value.