Show empty values as zero in line chart with set analysis

[stats101]

Hi,

I have records with empty date entries like the following:

Date	Count	Activity
07/01/2016	5	View
08/01/2016	10	View
08/01/2016	5	Create
10/01/2016	5	View
12/01/2016	2	Create
13/01/2016	6	View

I am using the following expression sum({<Activity={'View'}>}Count) to try and produce a line chart for view activity only, however it skips the intervening dates where rows with the value do not exist. It works interestingly when I remove the set analysis. I am using a master calendar.

Any help appreciated.

Thanks,

Message was edited by: Shuhel Miah with new detail

[#2]

This video helped me with it. It might be able to help you.

https://www.youtube.com/results?search_query=qlik+sense+master+calendar

https://www.youtube.com/watch?v=ek_ITfvCnHw

[stats101]

Hi Lauren,

Thank you for the response. I did a bit more investigation work, and have realised that the set analysis query is causing the behavior. Have updated my original question.

Regards,

Shuhel

[sunny_talwar · Accepted solution]

Try this expression:

Sum({<Activity={'View'}>}Count) + Sum({1}0)

and uncheck 'Suppress Zero Values' on the presentation tab.

[stats101]

I had to remove the 1 as it was ignoring selections i.e. Sum({<Activity={'View'}>}Count) + Sum(0) but it works. Excellent!