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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QuarterName in set analysis

Hi, hope you can help me, I created a field in my script QuarterName(UNIT.SOLD_DATE) as UNIT.SOLD_QTR,

so that I can use it in my set analysis, sum({<UNIT.SOLD_QTR = {$(=QuarterName(today()))}>} UNIT.TOTALSOLD)

but I think I'm getting the syntax wrong, can anyone help me please, Thx Simon

Labels (1)
1 Solution

Accepted Solutions
Clever_Anjos
Support
Support

Would be easier if you attach your qvw, but try this first

sum({<UNIT.SOLD_QTR = {"$(=QuarterName(today()))"}>}UNIT.TOTALSOLD

View solution in original post

2 Replies
Clever_Anjos
Support
Support

Would be easier if you attach your qvw, but try this first

sum({<UNIT.SOLD_QTR = {"$(=QuarterName(today()))"}>}UNIT.TOTALSOLD

Not applicable
Author

Perfect, thank you