topic Re: Help with set analysis? in QlikView

Help with set analysis?

Anonymous — Tue, 07 May 2013 16:22:03 GMT

Hello,

Currently I'm using the following expressions

=count( {<REPORT_YEAR={$(vCurrentYear)>}AC_SERIAL)

I want to to include a condition ,which only shows values which older than or equal to current month,all other values must show null for future months

I know we have to you month(today()) function ,inside the set expression, but I running ionto syntax error

Thx

Re: Help with set analysis?

Tue, 07 May 2013 16:29:20 GMT

I believe you would have to use month={">=$(=month(today())")}

Re: Help with set analysis?

jagan — Tue, 07 May 2013 16:29:21 GMT

Hi,

If you have date field in your data then use this

=count( {<YearFieldName=, MonthFieldName=, QuarterFieldName=, DateFieldName={'<=$(=MonthEnd(Today()))'}>}AC_SERIAL)

Hope this helps you.

Regards,

Jagan.