Use of ONLY-function

[Anonymous]

Hi all,

I am trying to accomplish something similar than listed here http://community.qlik.com/thread/23994;

use expression to filter the value 'On hold' away from a listbox displaying StatusName.

Based on the examples listed at the link I tried

=Only({<StatusName-={'On hold'}>}StatusName)

AND

=Only({<StatusName={'*'}-{'On hold'}>}StatusName)

but they did not work. In fact, after the change the listbox displays only its caption - no values at all.

Can you think of something that is wrong in my approach?

Thanks,

Juho

[Gysbert_Wassenaar · Accepted solution]

What are you trying to do? Do you want to hide one value in a listbox? If so try as expression =if(StatusName<>'On hold',StatusName)

If not please post an example.

• Preparing examples for Upload - Reduction and Data Scrambling.

[Anonymous]

Just what I wanted to do, thanks!