topic Create Cero Values to month that not have value in QlikView

Create Cero Values to month that not have value

fkeuroglian — Wed, 25 Nov 2020 16:16:04 GMT

Hi i have a table that contain info to some month, but NOT for all months

i wan to know if it possible to add 0 (cero) value to the months i do not have any info

attached an example

thanks a lot

FernandO K.

Re: Create Cero Values to month that not have value

sunny_talwar — Wed, 06 Jul 2016 16:06:52 GMT

Are those months available in the application? I mean do they even exist in the application? Unless they are missing, we should be able to see them I think

Re: Create Cero Values to month that not have value

fkeuroglian — Wed, 06 Jul 2016 17:08:24 GMT

Hi Sunny

The months and year came from the fact table "CARTERAUNIFICADA" and there is no value, i will want to create in cero value or other possibilty?

for this particular combination not contain value, that is my issue

What do you suggest, i think that there will be a chance to do it in set analysis?

Thanks a lot

Fernando K.

Re: Create Cero Values to month that not have value

sunny_talwar — Wed, 06 Jul 2016 17:21:36 GMT

Set analysis won't work if the information isn't available. I would suggest creating a master calendar to populate the missing data and then I feel that you should be fine