Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tomovangel
Contributor III

Bar Chart Show null values

Hello guys,

     This might be something quite easy, but I haven't been able to think it out.

I want to show on a bar chart, all the days from the month, and then when I select some of my employees, i want to see the days he was working, as well as the days he wasn't working ?

Screenshot_1.png

Screenshot_9.png

I have checked Include zero values in both places, under the Dimension tab, and under the Add-ons tab?

Any Ideas?


Thanks in advance for the answer ;-))

1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: Bar Chart Show null values

may be try something like this, by adding + sum({1} 0) in the expression -

What does it mean sum({1} 0)?

2 Replies
Digvijay_Singh
Honored Contributor III

Re: Bar Chart Show null values

may be try something like this, by adding + sum({1} 0) in the expression -

What does it mean sum({1} 0)?

tomovangel
Contributor III

Re: Bar Chart Show null values

Yep, I thought it could be something like this, Thanks mister Singh !

Community Browser