Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview User,
I am trying to write an expression which already includes Set analysis, and now I want to add in the Month function nut am unsure of the correct code to incorporate it. My expression is below and any help would be greatly appreciated
sum({$<Week_Number,Month,QuarterName,FiscalYear,Month(FactDateNum)=P(FactDateNum_prevMonth2)>} If(RTT_WEEKS_WAIT <'18', RTT_COUNTER)))
Kind Regards
Helen
Try to create Month in script and then use same field it will achieve.
Try to create Month in script and then use same field it will achieve.