Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
salleninsd
Creator
Creator

Static KPI

I am trying to have a static KPI that is not influenced by filters selected in the app.  I'm not sure of the syntax that I need to use Year, Quarter, and Month as the filter.  This format is adding them all together when filters are selected.  When all is unfiltered, the answer is correct:

Sum({$1<Year={1998}>+$1<Quarter={"Q1"}>+$1<Month={"Mar"}>} LineSalesAmount)

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

Sum({1<Year={1998},Quarter={'Q1'},Month={'Mar'}>} LineSalesAmount)

View solution in original post

2 Replies
petter
Partner - Champion III
Partner - Champion III

Sum({1<Year={1998},Quarter={'Q1'},Month={'Mar'}>} LineSalesAmount)

salleninsd
Creator
Creator
Author

Thank you!  That works perfectly.  Still learning syntax .

Take good care,

Scott