How to display past records based on current selec... - Qlik Community

baarathi · ‎2017-10-26

How to display past records based on current selections?

For example, if we select a particular year-month, previous 3 or 4 months details should be displayed....

Anil_Babu_Samineni · ‎2017-10-26

Perhaps this?

Sum({<[year-month] = {">=Condition <= Condition"}>} Measure) // Here, condition you can use as per needs

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

tresesco · ‎2017-10-26

Check it here: Selected Dates Range for idea.

baarathi · ‎2017-10-26

Thanks a lot

baarathi · ‎2017-10-26

Thanks a lot but sir,is there a way other than using set analysis?

baarathi · ‎2017-10-28

Sir... Should we apply this query as dimension or expression?

tresesco · ‎2017-10-30

Ideally - expression.