topic Re: write Format in QlikView

write Format

Fri, 31 May 2013 06:18:58 GMT

Hii,

I want to write expressions clause

=Count({<SD_WorkingDay={'1'},SD_Ay=num(Month(vbugun))>},GVG_UID)

=Count(if (SD_Ay=(Month(vbugun)),GVG_UID)) working

=Count({<SD_WorkingDay={'1'}>}GVG_UID) working

I wonder why it does not work we combined two sentences

=Count({<SD_Ay=num(Month(vbugun))>},GVG_UID) not working

Thank You

Sokkorn — Fri, 31 May 2013 06:30:35 GMT

Hi iker,

This one should work

=Count({<SD_WorkingDay={'1'},SD_Ay= {$(=num(Month(vbugun)))}>},GVG_UID)

=Count({<SD_Ay= {$(=num(Month(vbugun))}>},GVG_UID)

Regards,

Sokkorn

er_mohit — Fri, 31 May 2013 06:32:12 GMT

Try this

Count({$<SD_Ay={"$(=Month(vbugun))"},SD_WorkingDay={1}>}GVG_UID)

Fri, 31 May 2013 06:50:02 GMT

This is working

Thank You er.mohit