Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense : How to restrict graph for 5 years

Expression :

rangesum( below( count({  < EMP_HRIS = {"E"} >} [Emp Code]), 0, FYEAR))

-

count({<EMP_HRIS = {"L"} >} [Emp Code] )

Dimension : FYEAR

Q1.JPG

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

q2.JPG

11 Replies
Not applicable
Author

The same code working fine in Qlikview ,

Qlikview.JPG

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.

Not applicable
Author

Thanks siva , ITs working fine...