topic Re: Show all values for a dimension in QlikView

Show all values for a dimension

vireshkolagimat — Sat, 16 Nov 2024 21:22:57 GMT

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

Re: Show all values for a dimension

sunny_talwar — Tue, 19 Feb 2019 12:55:46 GMT

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

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

Re: Show all values for a dimension

vireshkolagimat — Tue, 19 Feb 2019 13:13:09 GMT

Hi, Even i got stuck at this point.

Thank you.

Re: Show all values for a dimension

sunny_talwar — Tue, 19 Feb 2019 13:14:19 GMT

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