topic Re: Set Analysis Issue in QlikView

Set Analysis Issue

Qlik__Vinodh — Wed, 16 Oct 2013 12:10:21 GMT

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

Wed, 16 Oct 2013 12:17:02 GMT

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 — Wed, 16 Oct 2013 12:24:54 GMT

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

Qlik__Vinodh — Wed, 16 Oct 2013 12:27:07 GMT

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

Qlik__Vinodh — Wed, 16 Oct 2013 12:28:18 GMT

Hi Aunez,

C-Date field is required with Len Function

tresB — Wed, 16 Oct 2013 12:42:06 GMT

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 — Wed, 16 Oct 2013 13:05:06 GMT

Thanks for reply, above two expressions are not working friend

tresB — Wed, 16 Oct 2013 13:31:51 GMT

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 — Wed, 16 Oct 2013 13:39:55 GMT

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