Solved: Set Analysis to find last set of observation - Qlik Community

Anonymous · ‎2017-10-25

I am trying display in my mini graphs only the last vDays observation - so for example my vDays variable is 4 so I would like to show only 04/10/2017,03/10/2017,04/01/2017,03/01/2017 ( there are gap between the dates ).

Any idea?

Thank you

Raphael

sunny_talwar · ‎2017-10-26

May be one of these:

Sum({<Date = {"$(='>=' & Date(Max(Date, $(vDays))))"}>}Points)

or

Sum(Aggr(If(Date >= Max(TOTAL <Name> Date, $(vDays)), Points), Name, Date))

View solution in original post

Anil_Babu_Samineni · ‎2017-10-25

PFA

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 · ‎2017-10-25

actually this show me the first vDays observation not the last? am am after the last, thanks

Anonymous · ‎2017-10-25

and also 04/01/2017 is treated same as 04/10/2017 so not working at all

Anil_Babu_Samineni · ‎2017-10-25

First issue resolved

And, second one "and also 04/01/2017 is treated same as 04/10/2017 so not working at all" - How?

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 · ‎2017-10-26

Not yet...

issue 1) I need the last set of observation (not first) so if vDays is 1 expecting to see only last observation Natalie 80 and Kim 90, not 67, 55

issue 2) it is the same Day value for month 01 and month 10 ?

Thank youy

sunny_talwar · ‎2017-10-26

May be one of these:

Sum({<Date = {"$(='>=' & Date(Max(Date, $(vDays))))"}>}Points)

or

Sum(Aggr(If(Date >= Max(TOTAL <Name> Date, $(vDays)), Points), Name, Date))

Anonymous · ‎2017-10-26

The bottom on is the one I was after, many thanks

sunny_talwar · ‎2017-10-26

Awesome