topic Re: how to exclude multiple values from a list box chart in QlikView

how to exclude multiple values from a list box chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi experts,

have a straight table chart to list some fields' values, according to what are selected for these fields which are shown as list box charts.

things are working fine, except that i'm not able to exclude multiple values from one of the fields -- sitemat

attached is the qvw file for your advice, and HAPPY NEW YEAR!

Re: how to exclude multiple values from a list box chart

Fri, 30 Dec 2016 08:01:14 GMT

... for example if THM91B and PHD22UJ045J are excluded from sitemat, it's expected that the straight table should show 8 lines

Re: how to exclude multiple values from a list box chart

ramasaisaksoft — Fri, 30 Dec 2016 10:16:03 GMT

can u check with ~ symbol

Re: how to exclude multiple values from a list box chart

robert_mika — Fri, 30 Dec 2016 11:14:34 GMT

if you exclude THM91B and PHD22UJ045J you will end up with PHD22UNAEH23 giving one value only.

Which is correct as other 'mat' are not associated with any 'sitemat' (they have null in that column)

Re: how to exclude multiple values from a list box chart

Mon, 02 Jan 2017 02:46:42 GMT

tried with that ~ symbol to exclude a value as below

How ever the result is opposite -- it SELECTs the the value rather than EXCLUDEs the value

Re: how to exclude multiple values from a list box chart

Mon, 02 Jan 2017 03:10:32 GMT

hi Mika,

thanks for the reply but i'm not sure if i understand the instruction. my difficulty is to EXCLUDE multiple values from a list box (sitemat, in my case) , and let the relevant results (plnt and mat, in my case) display as a straight table.

I thought this is easy to achieve however i don't know how to get it.

as i tried with Rama Sai's suggestion (to EXCLUDE a single value), it did not work as expected.

And if it would work to EXCLUDE both THM91B and PHD22UJ045J, the result should be as below (where the yellow highlighted rows were not displayed)

Re: how to exclude multiple values from a list box chart

Anil_Babu_Samineni — Mon, 02 Jan 2017 04:30:49 GMT

I want to ask 2 questions before offer you

1) If you select one value you want to exclude that value and showing other values?

2) If not, can you describe more simple

Re: how to exclude multiple values from a list box chart

Tue, 03 Jan 2017 02:52:09 GMT

Hi Anil,

answer to 1) -- the excluded one value shown in grey back ground, others shown in white background.

as that 2) assumed no answers required.

expecting your help.

Re: how to exclude multiple values from a list box chart

Fri, 06 Jan 2017 00:56:07 GMT

experts, any suggestion?

Re: how to exclude multiple values from a list box chart

Anonymous — Fri, 06 Jan 2017 06:37:15 GMT

Hi,

Try entering this into the sitemat searchbox:

-(THM91B|PHD22UJ045J)

Use the pipe i.e "|" to seperate the exact values.

-(Text1|Text2|Text3) (the - in front will exclude the values listed)

Hope it helps!

Re: how to exclude multiple values from a list box chart

Sat, 07 Jan 2017 09:15:17 GMT

Hi deez,

yes! it works when -(THM91B|PHD22UJ045J) is entered into mat search box.

many thanks!!!