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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

Set Analysis with a Function Incorporated

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

1 Reply
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful