topic Do not show Dimension containing in QlikView

Do not show Dimension containing

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Just started with Qlikview personnel,

I have a straight table (below) In the description i do not want the positions containing the word door to be shown or counted, how do i do this?

Re: Do not show Dimension containing

marcus_sommer — Wed, 08 Jun 2016 12:31:48 GMT

Maybe something like this: sum({< Description -= {'*door*'}>} Duration)

- Marcus

Re: Do not show Dimension containing

sunny_talwar — Wed, 08 Jun 2016 12:34:21 GMT

You can also create a flag in the script

LOAD *,

If(not WildMatch(lower(Description), '*door*', 1, 0) as Flag

From ....

And then use it like this:

Sum({<Flag = {1}>} Duration)

Re: Do not show Dimension containing

Anonymous — Wed, 08 Jun 2016 12:47:33 GMT

Both answers look like they could probably help but i am not sure where to put them,

@marcus, do i put this in the chart properties?

Sunny, Do you mean here (blue arrow ) for the script and then where do i put the other script.

Should have maybe explained that i am new to both Qlik and script

Thanks for the help

Des

Re: Do not show Dimension containing

Anonymous — Wed, 08 Jun 2016 14:31:03 GMT

I have the flag in and can see where it is , however where do i put the second script.

Sum({<Flag = {1}>} Duration)

des

Re: Do not show Dimension containing

sunny_talwar — Wed, 08 Jun 2016 15:25:55 GMT

Not sure which one of these is your Description field. Assuming it to be Text, you can try like this:

LOAD Type,

ID,

Entry,

...,

If(not WildMatch(lower(Text), '*door*', 1, 0) as Flag

FROM

(ooxml, embedded labels);

Re: Do not show Dimension containing

Saravanan_Desingh — Thu, 09 Jun 2016 01:47:33 GMT

Hi stalwar1‌

WildMatch is case insensitive. Do we still need lower function along with it? Just a thought..

Re: Do not show Dimension containing

sunny_talwar — Thu, 09 Jun 2016 02:21:23 GMT

I think you are right. I have never actually tested the case insensitiveness of WildMatch and I am always hesitant to use it without Lower or Upper

Re: Do not show Dimension containing

Anonymous — Thu, 09 Jun 2016 06:15:08 GMT

Thanks for the help, i was able to figure out the last bit.

Guess its time to get some training 🙂

/des

Re: Do not show Dimension containing

laxmanqlik — Thu, 09 Jun 2016 06:32:30 GMT

Wild match is not case sensitive.

Re: Do not show Dimension containing

laxmanqlik — Thu, 09 Jun 2016 09:39:46 GMT

Sunny can you help me avoid null values in bar chart