Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an interesting problem. I would like qlikview to show me all values in a chart even if the value is 0. I have charts that are used to compare different product types at my company. the issue is that when end-user selects a given product, qlikview re evaluates dataset and then returns where there are values. This can be confusing when One selection has 11 months of data and the other has 12. The charts are now "offset" and user has to understand that the relationship changed.
Here's a good example. When I make a selection, there is no data for March, April. In another subset there is data for March/April, so end-user gets confused when reading this. Is there a way to have qlikview include all my date values and just say '0' when there is no value? I tried "Show all values" box but this did not resolve the issue. Any help is appreciated.
Did you try unchecking Supress Zero values in Presentation tab? Try checking Zero on Bars and see ?
Hi,
You have to use OUTER JOIN in your script. See my attached .qvw, i think it's what you're trying to achieve.
regards
Hi Jean - thanks for your reply, however I don't think this is the solution I'm looking for. I shouldn't have to do any scripting to accomplish this as I'm not using more dataset. This is one dataset with different filters applied.
Did you try unchecking Supress Zero values in Presentation tab? Try checking Zero on Bars and see ?
HI Duke Luke,
If I have understood well, a possible solution would be a combination of:
I attach you the QV file of this sample:
Regards,
Héctor
How can I do this in Qlik Sense? I am also using Vislib...