topic Set analysis expression in QlikView

Set analysis expression

Wed, 13 Jun 2012 14:26:30 GMT

Hi,

Could anyone help me with this expression:

(

sum ({$<REDEMPTION_DATE={'=6/1/2012'},

GC_BUY_OR_REDEEM_R-={'B'}

>} REDEMPTION_AMOUNT)) is showing values though the REDEMPTION_DATE='06/09/2012' original expression is

(

sum ({$<REDEMPTION_DATE={'=$(=Date(VREDMPTION_DATE))'},

GC_BUY_OR_REDEEM_R-={'B'}

>} REDEMPTION_AMOUNT))

Pls help.

Thanks,

Swetha

Re: Set analysis expression

CELAMBARASAN — Wed, 13 Jun 2012 15:17:46 GMT

Hi,

sum ({$<REDEMPTION_DATE={'6/1/2012'},

GC_BUY_OR_REDEEM_R-={'B'}

>} REDEMPTION_AMOUNT)

Whats the issue in this expression you didnt mention anything about that?

Celambarasan

Re: Set analysis expression

Wed, 13 Jun 2012 15:19:31 GMT

Even though I need the data for only Redemption_date of 06/01/2012 its showing data for other dates too the filter of REDEMPTION_DATE is not working.

Re: Set analysis expression

CELAMBARASAN — Wed, 13 Jun 2012 15:26:46 GMT

Hi,

If You assign hard code value for Redemption Date in set analysis then filter won't work.

Re: Set analysis expression

Wed, 13 Jun 2012 15:28:44 GMT

I did nt assign a hard code value my original expression is

(

sum ({$<REDEMPTION_DATE={'=$(=Date(VREDMPTION_DATE))'},

GC_BUY_OR_REDEEM_R-={'B'}

>} REDEMPTION_AMOUNT))

and I have the VREDEMPTION_DATE as '06/01/2012' but its still showing values for REDEMPTION_DATE as '06/09/2012.

Re: Set analysis expression

CELAMBARASAN — Wed, 13 Jun 2012 15:45:12 GMT

Can you attach a sample app?