topic Re: Variable in Set analysis condition in QlikView

Variable in Set analysis condition

srik00001 — Thu, 09 Jul 2015 12:55:46 GMT

I am trying to pass a variable in the set analysis statement as below to calculate a customers in a range in product B and display only those customers in product A. I get an error with the below calculation. I have also attached the QVW !

='(' &chr(34) &

concat({$<Product={'Chains'},Customer = P({$<$(v_value)={"<=$(=$(v_max)*$(v_factor)) >=$(=$(v_min)*$(v_factor))"}>} Customer)>}

DISTINCT Customer, chr(34)&'|'&chr(34))

&chr(34)&')'

Re: Variable in Set analysis condition

alexandros17 — Thu, 09 Jul 2015 13:12:22 GMT

I think that the left side of a condition in set analysis cannot contain a variable....

Re: Variable in Set analysis condition

swuehl — Thu, 09 Jul 2015 13:21:30 GMT

Well, it can, but only if the dollar sign expansion expands it to a field name.

Re: Variable in Set analysis condition

swuehl — Thu, 09 Jul 2015 13:22:58 GMT

Not really sure what you are trying to achieve, so I changed quite a lot. See attached.

Re: Variable in Set analysis condition

srik00001 — Thu, 09 Jul 2015 14:33:30 GMT

The user will select a range and qlikview needs to limit the customers to Product= Chains within that range.

The list of customers will then be applied to all other objects.

Thanks for your help in pointing me in the right direction