Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
Highlighted
Partner
Partner

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

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

View solution in original post

2 Replies
Highlighted
Partner
Partner

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

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

View solution in original post

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.