Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Is the following setting checked?
Eli.
Hi EliGohar,
its already ticked
thanks
Hi @nareshshetty04 ,
Is it possible to share the current output you are getting?
Hi Abhijit,
i have attached the current o/p .Please check and let me know
thanks
can help me on this
@jagan
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