topic Need Help?? in QlikView

Need Help??

paulwalker — Sat, 07 Feb 2015 05:05:55 GMT

Hi All,

i have one more,

   ID, Date, Sales
     200, 02/02/2015, 250
     300, 02/03/2015, 235
     400, 02/04/2015, 190
     500, 02/05/2015, 290
     600, 02/06/2015, 250
     700, 02/09/2015, 200
      400, 02/04/2016, 190
     500, 02/05/2016, 290
     600, 02/06/2016, 250
     700, 02/09/2016, 200
]

i have 2016 years records also..

but i want compare with today() date only...

like this

Max(date) <=Today()

How to get current Vs previoue month (Means Feb Vs Jan)

How to write in SetAnalysis??

Thanks in Advance...

Re: Need Help??

PrashantSangle — Sat, 07 Feb 2015 05:21:05 GMT

Hi,

For Current Month

Sum({<Date={">=(date(Monthstart(Today())))<=date(Today())"}>}Sales)

For Previous Month

Sum({<Date={">=(date(Monthstart(Addmonths(Today(),-1)))<=date(AddMonths(Today(),-1))"}>}Sales)

Note: Modify it according to Date Format.

Regards

Re: Need Help??

mohammadkhatimi — Sat, 07 Feb 2015 07:31:09 GMT

Hi,

Try the following Expression:

For Current Month

=Sum({<Date={'>=$(=date(Monthstart(Today())))<=$(=date(Today()))'}>}Sales)

For Previous Month

=Sum({<Date={'>=$(=date(Monthstart(Addmonths(Today(),-1))))<=$(=date(Addmonths(Today(),-1)))'}>}Sales)

Regards,

Er.Mohammad

Re: Need Help??

paulwalker — Sun, 08 Feb 2015 18:41:09 GMT

Hi Max,

I am not getting value..

Please can you check once..????

PFA,

Re: Need Help??

PrashantSangle — Mon, 09 Feb 2015 04:39:55 GMT

Hi,

Try with suggestion given by mohammadkhatimiti

Regards,

Re: Need Help??

jagan — Mon, 09 Feb 2015 05:01:10 GMT

Hi,

Use below expressions

Current Month

=Sum({<Date={'>=$(=MonthStart(Today()))<=$(=Today())'}>} Sales)

Previous Month

=Sum({<Date={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} Sales)

Hope this helps you.

Regards,

Jagan.

Re: Need Help??

senpradip007 — Mon, 09 Feb 2015 05:04:54 GMT

PFA, hope it will help.

Re: Need Help??

kushalthakral — Mon, 09 Feb 2015 05:28:31 GMT

Dear Paul

i have tried the formula as suggested by Jagan, and it is giving correct result. You can proceed with the formula suggested.

Regards

Kushal T