Trying to make variable to get the value of all the possible fields

[#1]

Hello guys, I'm new to QlikView and I've encountered a problem. I have 4 different fields from which I can select the data for my charts. After selecting from 2 of them, I only have one possible choice in the other 2, so I would like my 2 variables linked to those 2 fields to take the values from there automatically (without clicking on the only possible selection that I can make).

Thank you

PS: I have the free version so I can't open files created my someone else, so if you could explain me in words would be great.

[hic · Accepted solution]

If you assign your variable the following value

     '=Only(Field)'

(including the equal sign) it will get the value for that field - but just if there is only one value.

HIC

[#3]

This is fantastic. This is exactly what I wanted. Thank you so much!

Have a good evening!

Adrian