Re: Set analysis to display 4 Year data - Qlik Community

Anonymous · ‎2018-03-13

Hi,

I have 6 years of data in my DB but in chart i want to display only 4 years.

Eg: 2013 ,2014,2015,2016,2017,2018

Expected result : 2015,2016,2017,2018 in dimension of chart.

But all 6 years should be there in the list box filter.

If I want to see 2013 data I can select from list box.

Please help with the solution.

Thanks.

kaushiknsolanki · ‎2018-03-13

Hi,

You need Set analysis for the same.

Try below example.

Sum({<Year = {">=$(=Max(Year)-3)"}>}Sales)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Anil_Babu_Samineni · ‎2018-03-13

May be implicit command helps you

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2018-03-13

Hi,

I have already a dimension in chart as below

=if('20'& Right(TMonth.Year,2)<>20,'20'&Right(TMonth.Year,2))

which is displaying the year of 2015 -2016 as 2016 and so on.

I have to display only 4 years in that ie.2015 2016 2017 2018

I dont want the sum of sales.Just the year needs to be filtered.

Please help if you have solution to this.