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

[vishalgoud]

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]

Hi,

Please check this.

https://community.qlik.com/blogs/qlikviewdesignblog/2015/10/19/excluding-values-in-set-analysis

[vishsaggi]

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

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

[shiveshsingh]

try this

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

[jyothish8807]

Hi Vishal,

try this:

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

Br,

KC

[anat]

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

value should be in double quotes.

[vishalgoud]

Thanks all for the reply

How to avoid these ST category in dimension as well.

[shiveshsingh]

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