Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
mishraamit2485
Creator
Creator

Blanks in pivot & unable to create cyclic group

Hi All,

I have a heatmap to work on...

1st Prob:

Now in one representation(Rep 1) some blanks are coming like (Product 1,2,3 does not exist for country D and product 7 not for B), see the app, but same case is not there with Rep 2.

Now my problem is I want show this "-"  in Rep1 as something which can help user to tell that this product does not exist, any way to do that.

2nd Prob:

In the above e.g. Country dim is actually a cyclic group(Region,SubReg,Country) some how i'm able to crate the cyclic group but whn I'm moving it to next box it is converting into a single dimension, why is that happening.

10 Replies
mishraamit2485
Creator
Creator
Author

Kiran its not null, its missing!!!