topic Re: Aggregation syntax help in QlikView

Aggregation syntax help

hobanwashburne — Fri, 26 Jul 2013 14:07:33 GMT

I have a text box in which I want to display sales for a particular month, the following line works:

=num(Sum ({$<FiscalPeriod={201303}>}NetSales),'$#,##0')

Now I want to replace the static text “201303” with either a variable (vGLPR) or the
calculation to get back to the correct month (date(AddMonths(Today(),-4),'YYYYMM')

Let vGLPR = date(AddMonths(Today(),-4),'YYYYMM');

Re: Aggregation syntax help

jerem1234 — Fri, 26 Jul 2013 14:16:10 GMT

Try this:

=num(Sum ({$<FiscalPeriod={$(=date(AddMonths(Today(),-4),'YYYYMM'))}>}NetSales),'$#,##0')

Re: Aggregation syntax help

hobanwashburne — Fri, 26 Jul 2013 14:20:38 GMT

Thank you, does anyone know what the variable method would look like?

Re: Aggregation syntax help

jerem1234 — Fri, 26 Jul 2013 14:46:19 GMT

This should be it:

=num(Sum ({$<FiscalPeriod={'$(vGLPR)'}>}NetSales),'$#,##0')

and let defintion of vGLPR be: =date(AddMonths(Today(),-4),'YYYYMM')