Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

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.

1 Solution

Accepted Solutions
Employee
Employee

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

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

Image1.png

2 Replies
Employee
Employee

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

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

Image1.png

Not applicable

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

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

Have a good evening!

Adrian

Community Browser