Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

1 Solution

Accepted Solutions
sadasiva
Contributor

Re: Qlik Sense : How to restrict graph for 5 years

Hi Mahi,

=if(FYEAR<max(Total FYEAR-4),max(Total FYEAR-4),FYEAR),


This will remove 2012.


Regards,

Sadasiva

11 Replies

Re: Qlik Sense : How to restrict graph for 5 years

Try the limitation option in dimension.

Keep it to Fixed 5.

and sort your chart by year dimension.

Regards,

Kaushik Solanki

Not applicable

Re: Qlik Sense : How to restrict graph for 5 years

This option is in Qlikview not in QlikSense....

Where is this option in Qlik Sense ?

Re: Qlik Sense : How to restrict graph for 5 years

Capture.PNG

The option is under dimension.

Regards,

Kaushik Solanki

Not applicable

Re: Qlik Sense : How to restrict graph for 5 years

If I am using below options .. my Data is showing wrongly... see below graph which is showing wrong values.

A1.JPG

2.JPG

For 2017 count should be 4277 not 2434 , Pls see my expression (above) as count is accumulating per year

Re: Qlik Sense : How to restrict graph for 5 years

How about using this

=(RangeSum(Below(Count({< EMP_HRIS = {"E"} >} [Emp Code]), 0, FYEAR)) - Count({<EMP_HRIS = {"L"}>} [Emp Code])) * Avg({<Year = {"$(='<=' & (Max(FYEAR)-1) & '<=' & Max(FYEAR))"}>} 1)

sadasiva
Contributor

Re: Qlik Sense : How to restrict graph for 5 years

Hi Mahi,

You are accumulating values from your business starting years, if you want to display latest 5, in your dimension you need to connsider all the years till 2013 as yr 2013, then the expression will give correct numbers.

Ex: if(FYEAR='2011' or FYEAR='2012' or FYEAR='2013','2013',FYEAR)


Regards,

Sadasiva

Not applicable

Re: Qlik Sense : How to restrict graph for 5 years

Its not working ,

Tried in other way... Its working ...

=if(FYEAR<max(Total FYEAR-4),max(Total FYEAR-4),FYEAR)

Not applicable

Re: Qlik Sense : How to restrict graph for 5 years

I am able to restrict for 5 years with the below code ... but additionally its showing 2012 year which I dont want to show in my graph , How to hide or avoid 2012 in the graph.

New.JPG

Dimension :

=if(FYEAR<max(Total FYEAR-5),max(Total FYEAR-5),FYEAR)

Expression:

Existing :

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

+

(

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

-

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

)

Joiners:

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

+

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

)

Leavers:

if( FYEAR>=max(Total FYEAR-5),

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

Kindly provide any suggestions here...

sadasiva
Contributor

Re: Qlik Sense : How to restrict graph for 5 years

Hi Mahi,

=if(FYEAR<max(Total FYEAR-4),max(Total FYEAR-4),FYEAR),


This will remove 2012.


Regards,

Sadasiva

Community Browser