topic Re: Check if element is selected in QlikView

Check if element is selected

danosoft — Fri, 30 Aug 2019 10:40:46 GMT

Hi, i need to check if my element in my visualization is selected, how can i do that?

In the picture one you can see the object, this name is LB144

The expression in it is: =if(FORNITORE='PWE',FORNITORE)

but:

a. when i do some selection in my layout if i use this in a textbox for example: =GetFieldSelections(FORNITORE)

the resulset is: ECO,PWE

b. if i check the value with this: =[FORNITORE]

the resultset is: -

so i need to check the element becouse i want only have for resulset PWE, how can i check my element if is selected or not?

thanks

MindaugasBacius — Fri, 30 Aug 2019 11:01:00 GMT

I strongly suggest using Only:

=if(Only(FORNITORE)='PWE',FORNITORE)

martinpohl — Fri, 30 Aug 2019 11:16:27 GMT

Hi,

when you select in a field many values and select in another field additional values then will:

-in a listbox the values reduced to values who have relationship in both selections

but when using getfieldselections you will see the based values on field one.

So if you want to see what is the result of both maybe use concat(distinct yourfield , ',')

Regards

danosoft — Fri, 30 Aug 2019 12:20:08 GMT

Thanks, but i only want to see PWE in FORNITORE field, not all those values when i choose some selections