topic Use of ONLY-function in QlikView

Use of ONLY-function

Anonymous — Mon, 15 Jul 2013 06:12:10 GMT

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 — Mon, 15 Jul 2013 06:17:36 GMT

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.

Anonymous — Mon, 15 Jul 2013 06:27:15 GMT

Just what I wanted to do, thanks!