Set Analysis with a Function Incorporated

[helen_pip]

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

[Anil_Babu_Samineni · Accepted solution]

Try to create Month in script and then use same field it will achieve.