topic Re: QuarterName in set analysis in QlikView

QuarterName in set analysis

Wed, 16 Sep 2015 14:33:57 GMT

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

Clever_Anjos — Wed, 16 Sep 2015 14:39:04 GMT

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

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

Wed, 16 Sep 2015 14:41:34 GMT

Perfect, thank you