Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis - One criteria and Month

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

1 Solution

Accepted Solutions
Not applicable
Author

hello. quite good:


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

View solution in original post

4 Replies
Not applicable
Author

hello. quite good:


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

Not applicable
Author

Thank you!

Not applicable
Author

WAS THE correct ANSWER? PLS QLIK ON IT

Not applicable
Author

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!