Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ronitfromvgold
New Contributor II

how to show missing data in a table

I need to show a visiting report.

The data includes:

customer name

project name

visiter

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?

Tags (1)
1 Solution

Accepted Solutions
bwisealiahmad
Valued Contributor

Re: how to show missing data in a table

Any way you can share the app?

What about messing around with these options here on properties.

Screenshot.PNG

8 Replies
agigliotti
Honored Contributor II

Re: how to show missing data in a table

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.

ronitfromvgold
New Contributor II

Re: how to show missing data in a table

Thank you Andrea, how ever it didnot work.

Please see a copy of the result:

PIC.JPG

bwisealiahmad
Valued Contributor

Re: how to show missing data in a table

You have ticked it for the Count value. Are you sure it's not based on one of the dimensions it is suppressing values?

agigliotti
Honored Contributor II

Re: how to show missing data in a table

I think you should use something as Count(DISTINCT Visiter) instead of Count(Date) as your expression in pivot table.

ronitfromvgold
New Contributor II

Re: how to show missing data in a table

None of the dimntsions is clicked as suppressing values...

bwisealiahmad
Valued Contributor

Re: how to show missing data in a table

Any way you can share the app?

What about messing around with these options here on properties.

Screenshot.PNG

ronitfromvgold
New Contributor II

Re: how to show missing data in a table

Yes!

I still need to "play" with it.

But it does give much more options.

Thank you

bwisealiahmad
Valued Contributor

Re: how to show missing data in a table

Glad to hear. You are welcome

Community Browser