topic Re: How to avoid particular group in filter and expression..?? in QlikView

How to avoid particular group in filter and expression..??

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

Hi all.

Am showing sum of duration for different call type

Now we have to avoid one particular category called ST domestic. ST interinternat etc .. Which will start with ST only.

Please send me the procedure for doing this .

Dimension name is call_type and exp is sum(duration)

qlikviewwizard — Mon, 28 May 2018 22:03:03 GMT

Hi,

Please check this.

vishsaggi — Mon, 28 May 2018 22:47:32 GMT

‌Try this? And you want one particular category or string that starts with ST?

= Sum({<call_type -= {“$(=wildmatch(call_type, ‘ST*’)>0”} >}Duration)

shiveshsingh — Tue, 29 May 2018 04:37:09 GMT

try this

sum({<call_type -={'Your excluded call types'}>}duration)

jyothish8807 — Tue, 29 May 2018 04:45:45 GMT

Hi Vishal,

try this:

= Sum({<call_type -= {‘ST*'} >}Duration)

Br,

anat — Tue, 29 May 2018 07:52:59 GMT

=sum({<call_type-={"ST*"}>}Duration)

value should be in double quotes.

vishalgoud — Tue, 29 May 2018 10:04:59 GMT

Thanks all for the reply

How to avoid these ST category in dimension as well.

shiveshsingh — Tue, 29 May 2018 11:41:04 GMT

=if(not wildmatch(call_type,'ST*'),call_type)