Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Karl_Hart
Contributor

Show result based on condition (not based on selection)

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?

Tags (3)
1 Solution

Accepted Solutions
Partner
Partner

Re: Show result based on condition (not based on selection)

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

2 Replies
Partner
Partner

Re: Show result based on condition (not based on selection)

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

Karl_Hart
Contributor

Re: Show result based on condition (not based on selection)

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