topic Re: Using variable in SET Analysis in QlikView

Using variable in SET Analysis

pauljohansson — Mon, 23 Sep 2013 13:35:48 GMT

Hi,

Im using a indirect Set Analysis where I want to select the Sum of deposits for the Customers that NOT are associated to the current selection. I also want to take into account a variable value. I get stuck when im combining selections and variable values in my indirect analysis SET.

My Base expressions - this works fine!

IF (vPaymentActivity = 'Payment Activity',
if(Sum(pmtAmount_EUR_Deposit)>=vPaymentAmount, Sum(pmtAmount_EUR_Deposit),),
Sum(
{<PaymentDate=E(PaymentDate),
pmtAmount_EUR_Deposit=E(pmtAmount_EUR_Deposit)>} pmtAmount_EUR_Deposit))

However, I want pmtAmount_EUR_Deposit do be dynamic, linked to a variable, NOT to the selection in the field. What I would assume to work is:

Instead of referencing to the selections in field pmtAmount_EUR_Deposit, i want to reference to the vPaymentAmount.

Any advice are welcome,

thanks in advance,

Paul

Re: Using variable in SET Analysis

michael_maeuser — Mon, 23 Sep 2013 13:59:01 GMT

try this

Re: Using variable in SET Analysis

CELAMBARASAN — Mon, 23 Sep 2013 14:12:00 GMT

Use set analysis in E() function

Sum(
{<PaymentDate=E(PaymentDate),
pmtAmount_EUR_Deposit=E({<pmtAmount_EUR_Deposit = {">=$(vPaymentAmount)"}>} pmtAmount_EUR_Deposit)>} pmtAmount_EUR_Deposit)