Do not show Dimension containing

[Anonymous]

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?

[marcus_sommer]

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

- Marcus

[sunny_talwar]

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)

[Anonymous]

Hi

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

[Anonymous]

Hi

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

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

des

[sunny_talwar]

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);

[Saravanan_Desingh]

Hi stalwar1‌

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

[sunny_talwar]

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

[Anonymous]

Hi

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

Guess its time to get some training 🙂

/des

[laxmanqlik]

Wild match is not case sensitive.