last year data in Qlik Sense using expression

[vanand3535]

Hi all,

I need to find the Sales in prior season .

Season= 2013,2014,2015,2016,2016

Logic :-

Prior season sales(2016)=  total sales(2013,2014,2015)

Prior season sales(2015)=total sales(2013,2014)

same for others...

How can I do this?

[rangam_s]

sum({<Season={"<$(=Max(Season))"}>}Sales)

Try this.

[Chanty4u]

may be this

sum({<Year= {"<$(=Max(Year))"}} >}Sales)

[vanand3535]

I need more than one year..

Ex:

I have "Season" as dimension where values are:-  2013,2014,2015,2016,2017

If I talked for total number of sales in Prior Season of 2017 = Total number of sales in all the year which is less than or earlier to 2017 = total number of sales(2013,2014,2015,2016)

same ,

total number of sales in Prior Season of 2016 =total number of sales(2013,2014,2015)

total number of sales in Prior Season of 2015 =total number of sales(2013,2014)

total number of sales in Prior Season of 2014 =total number of sales(2013)

total number of sales in Prior Season of 2013 = 0(Zero)   Because I have only from  2013-17

[vanand3535]

I need more than one year..

Ex:

I have "Season" as dimension where values are:-  2013,2014,2015,2016,2017

If I talked for total number of sales in Prior Season of 2017 = Total number of sales in all the year which is less than or earlier to 2017 = total number of sales(2013,2014,2015,2016)

same ,

total number of sales in Prior Season of 2016 =total number of sales(2013,2014,2015)

total number of sales in Prior Season of 2015 =total number of sales(2013,2014)

total number of sales in Prior Season of 2014 =total number of sales(2013)

total number of sales in Prior Season of 2013 = 0(Zero)   Because I have only from  2013-17

[MK9885]

Maybe use

sum({< Year={$(=(Max(Year))-1)}

>+< Year={$(=(Max(Year))-2)}

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

[pedrolyra]

Hey Vivek, try something like this

SUM({$<SeasonDate= {"<=$(=date(makedate(year(addmonths(max(SeasonDate),-12)),12,31)))"}>} Value)

You cant use this in a table with seasondate as dimension, i think this will work on kpis.

att

[vanand3535]

There is no date in my case

my Dimension and values are:-

Season={2013,2014,2015,2016,2017}

ex:- Sum({<.......................>}Sales)

In between how can i use the syntax?

[vanand3535]

Thanks for reply..

Let me test this syntax.

[MK9885]

In your case I guess you should use

sum({< Year={$(=(Max(Year))-1)}

>+< Year={$(=(Max(Year))-2)}

>+< Year={$(=(Max(Year))-3)}

>+< Year={$(=(Max(Year))-4)}>}Sales)

As you've 4 years excluding 2017