Set Analysis Issue

[Qlik__Vinodh]

Dear Fried,

How to Write in set analysis for bellow Expression. Pls Help me on it.

=Sum(if([LinkDate] <= vMaxDt

and (Len([C_Date]) <=0
   or
   [C_Date] > vMaxDt) and ([Y/N Flag]='N') ,[Amount]))
  

Thanks,

vind

[#2]

Hi,

I would try sth like:

sum({< {set1}*{set2}} + {{set3} *{set4}}>}, Amount)

where

set1= LinkDate ={"<=$(vmaxDt)"}

set2= C_Date ={""}

set 3 = C_Date={">$(vMaxDt)"}

set4 = [Y/N Flag] = {"N"}

Fabrice

[saumyashah90]

sum({<[LinkDate]<={'vMaxDt'},[Y/N Flag]={'N'},[C_Date]={'>=$(vMaxDt) <=0'}>} [Amount])

[Qlik__Vinodh]

thanks for reply, but it is C_Date is  need with Len function.

[Qlik__Vinodh]

Hi Aunez,

C-Date field is required with Len Function

[tresB]

Try like:

Sum({<[LinkDate]={"<=$(=vMaxDt)"}> * <[C-Date]={"=Len([C-Date])<=0"}> + <[C_Date]={">$(=vMaxDt)"}>

          * <[Y/N Flag]={'N'}>}[Amount])

OR,

Sum({ ( <[LinkDate]={"<=$(=vMaxDt)"}> * <[C-Date]={"=Len([C-Date])<=0"}> ) + (<[C_Date]={">$(=vMaxDt)"}>

          * <[Y/N Flag]={'N'}> ) }[Amount])

// depending upon your OR, AND combination logic second option should work if not the first one.

[Qlik__Vinodh]

Thanks for reply, above two expressions are not working friend

[tresB]

There could other issues like date format; variable expansion. It would be easier to understand and help that if you could upload a sample app.

[Qlik__Vinodh]

No, That Expression Going  Success, but need this in Set Analysis.