Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a timestamp dimension common for 4 tables.
Now if I plot this dimension against a measure on a Bar/Line chart if for some minute of the hour the value does not exist, it eliminates from the chart.
For example, if I am looking for different colors Shirts sold per minute of the day. My data for an hour say between 16:00 to 17:00 will look like this:
16:01 - 4
16:02 - 5
16:03 - 2 and so on for every minute till 17:00.
Now take a case of RED shirts
16:01 - 1
16:02 - 0
16:03 - 1
and so on.
When I select RED from the color filter on the sheet the dimension on the graph does not show 16:02.
In a nutshell, on any selection, if in a minute, I have 0 sales for any combination of selections, my chart of Sales per minute should reflect a zero for that minute so that I know intuitively in which minute my sales was ZERO.
Also, this leads to calculating false average lines on the graph. Like in the case of Red Shirts the average for 3 minutes should be 2/3 but if 16:02 is not displayed it calculates 1/1.
Any help on this would be much appreciated.
uncheck supress zero values on Presentation tab, also post some sample data app with desired o/p
https://www.resultdata.com/force-qlikview-to-show-zero-values-on-a-chart/
Hi vinieme12
Please look
I want 12:28 PM, 12:31 PM and 12:32 PM and 12:44PM on the x-axis (Dimension) with measure value as null
I have tried the above 2. Also in the measure, I have tried if condition as If (count(xyz) >0 ,count(xyz),0) it is also not working.
NOTE: "Time" Dimension is the joining key across 4 tables.
Above Snapshot is for a filter (Like RED Shirts) as mentioned in the original Question.
have you tried this?
Do the following:
https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Visualizations/time-aware-charts.htm