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: 
Qlik__Vinodh
Partner - Creator II
Partner - Creator II

Set Analysis Issue

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

8 Replies
Not applicable

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
Specialist
Specialist

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

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

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

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

Hi Aunez,

C-Date field is required with Len Function

tresesco
MVP
MVP

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
Partner - Creator II
Partner - Creator II
Author


Thanks for reply, above two expressions are not working friend

tresesco
MVP
MVP

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
Partner - Creator II
Partner - Creator II
Author

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