topic Re: Add missing value to Table in QlikView

Add missing value to Table

Douwe_KB — Thu, 09 Feb 2023 15:06:01 GMT

Dear,

I have a field called "Productcode" which has 80 possible values. I want to show them all, however some data points do not use all productcodes and thus do not show all product codes in the table. How do I add the missing product codes to the table for all data points?

Groepcode is the label for CProductgroep field. Here it only shows 10 of the 80 possible values, they all range from 0-999. I want to find a way to represent all these values in the CProductgroep for all data points however I can't think of a way to do this. Any help is appreciated.

Re: Add missing value to Table

edwin — Tue, 21 Feb 2023 19:02:03 GMT

are you saying you have 80 dimension values and since only 10 of them have data points associated, then the other 70 are not represented? it would depend on what your expression is. for example if you are doing a simple count or sum, any dimension that have no measure associated will result in 0. however, if you have a set analysis modifier that excludes the 70 other values then yes they will not be included.

pls post your expression as that will help figure out your problem

Re: Add missing value to Table

edwin — Tue, 21 Feb 2023 19:14:20 GMT

here is an example as this is very similar to this one:

https://community.qlik.com/t5/QlikView-App-Dev/Generating-data-in-Bar-chart-or-backend/td-p/2037930

this is the data:

there are only 2 data points but there are a number of Dates.

if you use simple sum:

dimensions with no associated data points = 0

however, if you use set analysis:

the other dimension values are not included as they dont satisfy the set analysis modifier condition.

now if you add the following:

so you can combine them (and the final expression will depend on what is required, this is just an example)