Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

meizheng
New Contributor III

Force show all zero values for 2nd dimension in bar chart x-axis

Hi,

I want to add a dummy Application name ("AppX") to force show all ageing months regardless of filter selection. How can I go about (using set analysis?) to always display all months? Or is there any other way I can accomplish this?

Basically I want to be able to display all zeroes; i.e. circled in red - for all Departments.

I have managed to force show all Depts by adding + Avg({1} 0) to my Measure. Not sure if info is useful but my bar chart displays the latest month by default as follows:

if(isnull(Count({$<[PT.Month]={'$(=Max([PT.Month]))'}, [PT.isOverdue]={'Yes'}>}

                                ([App-Issue]))), 0,

    Count({$<[PT.Month]={'$(=Max([PT.Month]))'}, [PT.isOverdue]={'Yes'}>}

                                ([App-Issue]))) + Avg({1} 0)

Attached is the testing load script.


Screenshots for reference

     For Jan 17: Dept A and C has values for >=6 Months and >=1 Year

     For Jan 18: Dept B has values for >=6 Months

barchart-ss-comb.png

Tags (2)
2 Replies
YoussefBelloum
Esteemed Contributor

Re: Force show all zero values for 2nd dimension in bar chart x-axis

Hi,

did you try cheking "display null values" under complements ?

Complement.png

meizheng
New Contributor III

Re: Force show all zero values for 2nd dimension in bar chart x-axis

Hi,

It is checked already

ssss.PNG

Community Browser