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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

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
Employee
Employee

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