Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shumailh
Creator III
Creator III

Set Analysis Error

Couldn't recognize an error in the below code. Please help.

SUM({$< Rep_Day = {$(#=ReportDay)}> * $< Rep_Month = {$(#=ReportMonth)}>} Deposit_Amount)



Regards,
Shumail

4 Replies
syed_muzammil
Partner - Creator II
Partner - Creator II

Hi,

SUM({$< Rep_Day = {$(#=ReportDay)} , Rep_Month = {$(#=ReportMonth)}>} Deposit_Amount)

shumailh
Creator III
Creator III
Author

Tried the same earlier but not working

syed_muzammil
Partner - Creator II
Partner - Creator II

Hi,

What is it you actually want to do? Try using num() . Added the = sign.

SUM({$< Rep_Day = {$(num(=ReportDay))} , Rep_Month = {$(=num(ReportMonth))}>} Deposit_Amount)

shumailh
Creator III
Creator III
Author

I try the below code and it's working but not working using set analysis Tongue Tied



SUM( if(Rep_Day = $(#=ReportDay), if(Rep_Month = $(#=ReportMonth), Deposit_Amount, 0)))