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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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!!!