topic Re: List Box without certain fields in QlikView

List Box without certain fields

knightwriter — Tue, 04 Aug 2015 11:04:47 GMT

Hi All,

I have a list box with 10 fields and I only want to show 5 of them. I have used the expression to remove one field before by using

=if([Car Colour] <> 'Blue', [Car Colour])

But when I use it the same expression for more than once nothing happens and the list of colours remain the same. Any suggestions?

=if([Car Colour] <> 'Blue', [Car Colour],

if([Car Colour] <> 'Red', [Car Colour],

if([Car Colour] <> 'Yella', [Car Colour],

if([Car Colour] <> 'Pink', [Car Colour],

if([Car Colour] <> 'Grey', [Car Colour],)))))

Anonymous — Tue, 04 Aug 2015 11:09:50 GMT

after the first condition the Car Colour will be displayed if it is not blue,

do you want that None of the colours match Car Colour will be used?

try this:

if (match[Car Colour],'Blue'.'Red','Yella','Pink','Grey')=0, [Car Colour],null())

maximiliano_vel — Tue, 04 Aug 2015 11:14:56 GMT

Perhaps this is what you looking for?

knightwriter — Tue, 04 Aug 2015 11:32:38 GMT

Great stuff, thank you.