Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Exclude values

Hi Community,

I have field that have manu values but I don't wanted show particular value from that list through button action.

For Ex:

Filed_Test:

AA

BB

CC

DD

RR

FF

.

.

.

.

I wanted to show all except DD.

9 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Create a listbox with a calculated dimension, like

=IF (Field_Test <> 'DD', Field_Test)

Add some logic that tests a button-controlled variable to see whether the listbox should show all values or filter some.

Best,

Peter

maxgro
MVP
MVP

Found this .qvw, maybe it can help you

Mark_Little
Luminary
Luminary

Hi,

Quickest is like Peter has suggested, if you are going to be using in a number of places i would do it in script.

like

IF(Field_Test <> 'DD', Field_Test)  as Field_Test1,


Mark

reddy-s
Master II
Master II

Hi Priya,

For restricting values in a list field , "IF" condition will serve your purpose as mentioned above my Mark and others.

priyarane
Specialist
Specialist
Author

Above all suggestion can work out in List box but I have to show the result in Straight table as dimension.

Mark_Little
Luminary
Luminary

Well all the above options would work in both a list box and dimension.

just add a calculated dimension, although if scripted you can just add it.

Mark

sunny_talwar

Then use a calculated dimension (Peter's suggestion should still work)

=IF(Field_Test <> 'DD', Field_Test)

hemhund2016
Creator
Creator

Hi ,

Use it in the straight table as below.

Dimension :  =IF(Field_Test <> 'DD', Field_Test)

Make sure you set the "Supress When value is null" for dimension.


Thanks,Hemanth.

thakkarrahul01
Creator
Creator

Calculated dimension with if condition should do the job.