Hidden expression to force zero value dimensions in chart.

[whiteymcaces]

I have a chart in QlikView with 2 expresions:-

1. Sum({<MonthYear = {'>=$(vMthYr13) <=$(vMaxMthYr)'}>} Qty)

2. Sum({1<MonthYear = {'>=$(vMthYr13) <=$(vMaxMthYr)'}>} 1)

Dimension = MonthYear

The second expression is used and has been marked as 'True' in the Hide Column option under the Presentation TAB in chart properties to force all 13 consecutive MonthYear's from vMthYr13 to vMaxMthYr to be visible in the chart, even when the value is zero.

Obviously, I cannot turn 'show all values' on, or 'Suppress Zero Values off, as this would result in 5 years of MonthYear record to show.

My question is how can I achieve this in Qlik Sense as there is no 'Hide Column' option?

[miskinmaz · Accepted solution]

Hi,

You can try for if condition like

          if(isnull(sum(<set analysis> qty)),0, sum(<set analysis>qty))

regards