Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
vireshkolagimat
Contributor III

Show all values for a dimension

Hi All,

I'm trying create pivot chart with supplier code and store name as dimension and Sales as metric.

I need to show the all the suppliers in the pivot irrespective of the sales. So whenever they select any shop, it should all the suppliers.

I've attached sample file for the reference.

 

Thank you.

Regards,

Viresh

3 Replies

Re: Show all values for a dimension

There is not easy way to do this... one way is to generate all the missing data for each combination of SupplierCode and StoreName.... or you can look at something like this

 

image.png

Problem is the null after Store1.... if you try to suppress null for StoreName dimension... then you will again go back to the same problem

vireshkolagimat
Contributor III

Re: Show all values for a dimension

Hi, Even i got stuck at this point.

Thank you.

Re: Show all values for a dimension

If you don't like this, the only option is to generate the missing data with 0 value in the script