Discussion board where members can get started with Qlik Sense.
I need to show a visiting report.
The data includes:
date of visit
I made a pivot table chart with the dimension:
customer name, project name, week (from date)
the expression is "count (date)" - in order to count how many visits were there at each project in each week.
Only I want to see not only the project that were visited, but the projects with no visits at that week.
How do I do that?
Go to Solution.
Any way you can share the app?
What about messing around with these options here on properties.
you can untick "Suppress Zero-Values" under Presentation.
In this way you can see even rows with 0 as expression, therefore all projects with no visits.
Thank you Andrea, how ever it didnot work.
Please see a copy of the result:
You have ticked it for the Count value. Are you sure it's not based on one of the dimensions it is suppressing values?
I think you should use something as Count(DISTINCT Visiter) instead of Count(Date) as your expression in pivot table.
None of the dimntsions is clicked as suppressing values...
I still need to "play" with it.
But it does give much more options.
Glad to hear. You are welcome