topic Re: Sale Range in QlikView

Sale Range

prma7799 — Fri, 23 Sep 2016 09:19:42 GMT

Dear All,

I am getting Sale for before September from below expression

sum({<Date={"<$(=floor(monthstart(vToday)))"}>}[Sale])/100000

Now I want from Today to last 6 months Sale

Can you please advise

miguelbraga — Fri, 23 Sep 2016 09:27:50 GMT

See this:

Best regards,

D.A. MB

tresB — Fri, 23 Sep 2016 09:28:44 GMT

For sales of today since last 6 months try like:

sum({<Date={">=$(=monthstart(vToday,-6)) <=$(=today())"}>}[Sale])/100000

trdandamudi — Fri, 23 Sep 2016 09:29:17 GMT

May be as below:

=Sum({<Date= {"$(='>=' & Floor(MonthStart(vToday())-6) & '<=' & Floor(vToday())"}>} [Sale])/100000)

Anil_Babu_Samineni — Fri, 23 Sep 2016 09:37:31 GMT

If you want last 6 months Data

You can try this too

sum({< Date= {" <= $(=AddMonths(Today(),-6))"}>} Sale)

sum({< Date= {" <= $(=MonthStart(Today(),-6))"}>} Sale)

sum({< Date= {" <= $(=MonthStart(Today(),-6,0))"}>} Sale)

prma7799 — Fri, 23 Sep 2016 09:40:52 GMT

I am using floor for default date