Solved: Set analysis - One criteria and Month - Qlik Community

Report Inappropriate Content · ‎2013-09-25

Hello everyone,

I'm trying to set up a gauge chart where the sum if of a pre-set criteria and then linked to current month. Please can you put me right, the formula I am using is below where I want the sum to be where phase is equal to 'community' and current month.

sum({<PHASE='COMMUNITY',MONTH={"$(=monthstart(today()))"} >} VALUE)

With thanks,

Simon

Report Inappropriate Content · ‎2013-09-25

hello. quite good:

sum({<PHASE={'COMMUNITY'},MONTH={"$(=month(today()))"} >} VALUE)

View solution in original post

Report Inappropriate Content · ‎2013-09-25

hello. quite good:

sum({<PHASE={'COMMUNITY'},MONTH={"$(=month(today()))"} >} VALUE)

Report Inappropriate Content · ‎2013-09-25

Thank you!

Report Inappropriate Content · ‎2013-09-25

WAS THE correct ANSWER? PLS QLIK ON IT

Report Inappropriate Content · ‎2013-09-25

All done, sorry couldn't see the button on the view I was earlier. Thank you, I'm now playing around with date fields in vFromDates so I may still break it!