topic Re: Show result based on condition (not based on selection) in QlikView

Show result based on condition (not based on selection)

Karl_Hart — Fri, 08 Aug 2014 10:12:48 GMT

I'm trying to have a text box that shows the description of a specified code

I want to write something along the lines of

=[PI Description] where [PI Code] = 'GK300'

This will always show the Description of the Code GK300.

What I dont want to do (but it works) is

=If([PI Code]='GK300', [PI Description])

as this will only show the description if GK300 is selected.

I hope this makes sense. Any ideas?

simenkg — Fri, 08 Aug 2014 10:14:20 GMT

only({$<[PI Code]={'GK300'}>}[PI Description])

Karl_Hart — Fri, 08 Aug 2014 10:18:24 GMT

Thanks, I've not come across the "only" function before. I'll read up on it.