topic Re: Use an expression value in Set Expression in QlikView

Use an expression value in Set Expression

mk95 — Thu, 26 Nov 2020 15:40:03 GMT

Hello everybody, i want to use the value of an expression in a set expression.

For e.g. my expression ist -->

if((only({<Jahr={"$(=max(Jahr))"}>}[AuslaufFlag])=1 and only({<Jahr={"$(=max(Jahr)-1)"}>}[AuslaufFlag])=0) or (only({<Jahr={"$(=max(Jahr))"}>}[AuslaufFlag])=1 and len(only({<Jahr={"$(=max(Jahr)-1)"}>}[AuslaufFlag]))=0),'Zugang',Null())

and now want to use the value "Zugang" for a set expression

like sum({$<Zugang={'Zugang'}>}[Bilanzwert zu EK])

But i get wrong values, can someone help me :)?

Re: Use an expression value in Set Expression

edwin — Thu, 26 Nov 2020 16:28:29 GMT

i suggest try the following:
1. clear all filters (create a current selection object to make sure nothing is selected)
2. create a list for the field Zugang, then select the value 'Zugang'
3. create a text box with the expression sum([Bilanzwert zu EK])

the text object should have the same value as
sum({$<Zugang={'Zugang'}>}[Bilanzwert zu EK])

then re-create the scenario where you arent getting the expected value. check the selections (what filters you have) and go from there - you can try clear filters one by one

otherwise, attach a qvw

Re: Use an expression value in Set Expression

marcus_sommer — Fri, 27 Nov 2020 14:00:49 GMT

I assume it would be rather not possible because you would need to embed it within a $-sign expansion which operate only on a global level. Another possibility might be to use this within any aggr() constructs but I think it makes everything more complicated as it would be helpful. Therefore I suggest a small change to your approach and using it as a flag-calculation (maybe within a variable) like:

var:
if((only({<Jahr={"$(=max(Jahr))"}>}[AuslaufFlag])=1 and only({<Jahr={"$(=max(Jahr)-1)"}>}[AuslaufFlag])=0) or (only({<Jahr={"$(=max(Jahr))"}>}[AuslaufFlag])=1 and len(only({<Jahr={"$(=max(Jahr)-1)"}>}[AuslaufFlag]))=0),1,0)

and then as expression

sum([Bilanzwert zu EK]) * $(var)

- Marcus