topic Re: Previous Months Data in QlikView

Previous Months Data

Anonymous — Tue, 18 Apr 2017 17:51:01 GMT

Hi All,

Please if any one can help me on the solution.

I need to get the data for the previous months. For Eg:- If year is 2017 and Month selected is April then i should get the count records of (Jan+Feb+March+April). If i click March then it should get the count records of (Jan+Feb+March)

its bit urgent.

Thanks in Advance!!

Re: Previous Months Data

Anil_Babu_Samineni — Tue, 18 Apr 2017 17:55:20 GMT

Just use

Sum({<Month = {'$('<=' & =Max(Month))'}>}Sales)

Re: Previous Months Data

Anonymous — Tue, 18 Apr 2017 18:13:34 GMT

I replaced the Month and Sales with my field, but its giving error.

Re: Previous Months Data

Anonymous — Tue, 18 Apr 2017 18:38:44 GMT

Can anyone help here.