topic Variable declaration in QlikView

Variable declaration

lakshmanvepuri — Wed, 16 Sep 2015 07:33:53 GMT

Hi,

How to get the last 7 days in the reporting layer and Sum of the quantity.

Created variable : vLast7DaysFlag

Def: If(REP_DATE >= Date(Floor(Now()) - 14) AND REP_DATE <= Date(Floor(Now()) - 1), 1, 0)

Used in the Reporting as:

=Sum('$(=vLast7DaysFlag)'> QTY)

Still I am not get the data in the table.

Please advice on this..

Thanks a lot.

regards

LK Vepuri

vikasmahajan — Wed, 16 Sep 2015 07:36:18 GMT

=Sum( {<($vLast7DaysFlag)>} QTY)

sunny_talwar — Wed, 16 Sep 2015 07:50:55 GMT

May be try this:

=Sum({<REP_DATE = {"$(='>=' & Date(Today() - 14, 'YourDateFormat') & '<=' & Date(Today() - 1, 'YourDateFormat'))"}>} QTY)

sasiparupudi1 — Wed, 16 Sep 2015 08:28:14 GMT

Try

=Sum({<REP_DATE = {">=$(=max(REP_DATE)-14) <=$(=max(REP_DATE))"}>} QTY)

jagan — Mon, 14 Dec 2015 06:16:22 GMT

Hi Lakshman,

Check this link for set analysis expressions for various time periods

For last 7 days

Last 10 Days Sales

Sum({<Year=, Quarter=, Month=, Week=, REP_DATE ={‘>=$(=Date(Today()-7))<=$(=Date(Today()-1))’}>} QTY)

Hope this helps you.

Regards,

jagan.