Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

write Format

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

1 Solution

Accepted Solutions
er_mohit
Master II
Master II

Try this

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

View solution in original post

3 Replies
Sokkorn
Master
Master

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
Master II
Master II

Try this

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

Not applicable
Author

This is working

Thank You er.mohit