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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

Create Cero Values to month that not have value

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.

3 Replies
sunny_talwar

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

fkeuroglian
Partner - Master
Partner - Master
Author

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.

sunny_talwar

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