topic Exclude values in QlikView

Exclude values

priyarane — Fri, 11 Dec 2015 12:53:57 GMT

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:

I wanted to show all except DD.

Re: Exclude values

Peter_Cammaert — Fri, 11 Dec 2015 12:56:57 GMT

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

Re: Exclude values

maxgro — Fri, 11 Dec 2015 12:58:36 GMT

Found this .qvw, maybe it can help you

Re: Exclude values

Mark_Little — Fri, 11 Dec 2015 12:59:47 GMT

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.

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

Mark

Re: Exclude values

reddy-s — Fri, 11 Dec 2015 13:08:38 GMT

Hi Priya,

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

Re: Exclude values

priyarane — Fri, 11 Dec 2015 13:13:10 GMT

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

Re: Exclude values

Mark_Little — Fri, 11 Dec 2015 13:22:03 GMT

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

Re: Exclude values

sunny_talwar — Fri, 11 Dec 2015 13:22:20 GMT

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

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

Re: Exclude values

hemhund2016 — Fri, 11 Dec 2015 14:31:07 GMT

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.

Re: Exclude values

thakkarrahul01 — Fri, 11 Dec 2015 15:27:03 GMT

Calculated dimension with if condition should do the job.