Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Expression :
rangesum( below( count({ < EMP_HRIS = {"E"} >} [Emp Code]), 0, FYEAR))
-
count({<EMP_HRIS = {"L"} >} [Emp Code] )
Dimension : FYEAR
In the above graph I want to restrict to view only for 5 years ,
As my count is accumulating year wise , if I restrict at dimension (Year) level some data is missing see below screen shot.
Dimension :
=if(FYEAR>=max(total FYEAR-5),FYEAR)
Using same Expression
Now it’s showing wrong values
The same code working fine in Qlikview ,
The only one difference is did suppress null values in Qlikview.
I dont find option " Suppress Null values " in Qlik Sense , the same did in Qlikview.
Thanks siva , ITs working fine...