topic Set Analysis Error in QlikView

Set Analysis Error

shumailh — Sun, 18 Jul 2010 11:24:38 GMT

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

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

Regards,
Shumail

syed_muzammil — Sun, 18 Jul 2010 11:59:08 GMT

Hi,

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

shumailh — Sun, 18 Jul 2010 12:02:17 GMT

Tried the same earlier but not working

syed_muzammil — Sun, 18 Jul 2010 12:13:49 GMT

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 — Sun, 18 Jul 2010 12:20:41 GMT

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



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