Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)&')'
I think that the left side of a condition in set analysis cannot contain a variable....
Well, it can, but only if the dollar sign expansion expands it to a field name.
Not really sure what you are trying to achieve, so I changed quite a lot. See attached.
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