Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I'm new to qlikview and i'm facing a problem right now, I'm trying to display the history of consumption of a product, the chart displays only the weeks where there was a consumption, i need it to add all weeks with 0 value,
like week 1 value 0
week 2 value 0
week 3 value 400 and so on
Any ideas, thanks for your help
Actually i figured it out, just have to keep "show all Values" checked in dimension tab and uncheck "suppress missing" in the presentation tab.
Thank you @MayilVahanan
Based on ur screenshot, week 1, 2 are not associated with ur article. That's the reason, its not displaying in the chart.
You need to amend the data in ur data model with zero data for missed date / week.
@MayilVahanan Thanks for your reply.
Actually i did add all weeks in my data model, the problem is the chart only displays the weeks where the "qty conso" in not null, i tried show all values option but it didn't work.
Can you send the sample data?
Actually i figured it out, just have to keep "show all Values" checked in dimension tab and uncheck "suppress missing" in the presentation tab.
Thank you @MayilVahanan