0 values to be displayed

[nareshshetty04]

Dear All,

I want to display 0 values in the line graph eventhough data is not present in Qlik sense.

Dimension : MonthYear

my expression below

=Count(distinct {<
[Project Status]={'In Progress','Closed'},RolloutYear={'$(VAct_Roll_CDate)'},
[Performance Indicator (Go-Live)]-={'Delayed'},Unit={'CSAD'}>}ProjectName)
/Count(distinct{<
[Project Status]={'In Progress','Closed'},RolloutYear={'$(VAct_Roll_CDate)'},Unit={'CSAD'}
>}ProjectName) 

VAct_Roll_CDate : current year variable

please help on this 

thanks

[EliGohar]

Hi,

Is the following setting checked?

Eli.

[nareshshetty04]

Hi EliGohar,

its already ticked 

thanks

[abhijitnalekar]

Hi @nareshshetty04 ,

Is it possible to share the current output you are getting?

[nareshshetty04]

Hi Abhijit,

i have attached the current o/p .Please check and let me know

thanks

can help me on this

@Sunny  

@jagan

[abhijitnalekar · Accepted solution]

Hi @nareshshetty04,

In this case, I would suggest you use the master calendar to achieve the desired output.

you can refer the below link

https://community.qlik.com/t5/QlikView-Documents/Master-Calendar-Generation-Script/ta-p/1477450