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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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