Set expression using variable for field values

reema_dangwal — Wed, 01 Nov 2017 09:47:40 GMT

Hi All,

I have this requirement where:

1)I need to select a field(say Amount) from one table based on the matching client values in another table.

2.)There is no association between the two tables based on the client field, the association is required with some other field(Ekey).

Now, when I am creating a set expression using P(), it is working fine but when I am creating an expression using variable, it is not working in case I have more than one value for the Client field.

Ex:

sum({<EmpName=,B_ClientID=P(A_ClientID)>}Amount) is working for Emp1, Emp2

sum({<EmpName=,B_ClientID={"$(=vClient)"}>}Amount) is not working for Emp2, it is working for Emp1.

where vClient=Concat(Distinct A_ClientID,', ')

PFA the test qvw file for reference.

Due to some limitation, I need to use the variable set expression and not P() expression. Please suggest how this can be corrected.

Thanks,

Reema

Re: Set expression using variable for field values

tresB — Wed, 01 Nov 2017 09:58:26 GMT

May be like in attached sample?

Re: Set expression using variable for field values

reema_dangwal — Wed, 01 Nov 2017 10:02:27 GMT

Thanks that works.

topic Re: Set expression using variable for field values in QlikView

Set expression using variable for field values

Re: Set expression using variable for field values

Re: Set expression using variable for field values