Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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

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)

7 Replies
Highlighted
Master II
Master II

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

Highlighted
Champion III
Champion III

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

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

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

Highlighted
Master
Master

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

try this

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

Highlighted
Master II
Master II

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

Hi Vishal,

try this:

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


Br,

KC

Best Regards,
KC
Highlighted
Creator
Creator

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

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

value should be in double quotes.

Highlighted
Creator III
Creator III

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

Thanks all for the reply

How to avoid these ST category in dimension as well.

Highlighted
Master
Master

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

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