Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I draw accumulated barchart and line chart by
rangesum(above(Sum({$<Year ={'2019'}>} Unit), 0, RowNo()))
rangesum(above(Sum({$<Year ={'2020'}>} Unit), 0, RowNo()))
rangesum(above(Sum({$<Year ={'2021}>} Unit), 0, RowNo()))
rangesum(above(Sum({$<Year ={'2022'}>} Unit), 0, RowNo()))
I don't have data points for Mar and Apr for 2022, but the flat line is drawn for missing month. However, I only want to add line for the months have data point
I manually designated months to show here
if(Sum({<Month={'Jan','Feb'}>} Unit)=0,Null(),rangesum(above(Sum({$<Year ={'2022'}>} Unit), 0, RowNo())))
But is there any code that only shows month which is not NA or not missing?
I found that, in Qlik, if else doesn't require 'else' parameter always.
If(Sum({$<Year ={'2022'}>}Unit) > 0, RangeSum(Above(Sum({$<Year ={'2022'}>} Unit),0,RowNo())))
I found that, in Qlik, if else doesn't require 'else' parameter always.
If(Sum({$<Year ={'2022'}>}Unit) > 0, RangeSum(Above(Sum({$<Year ={'2022'}>} Unit),0,RowNo())))