Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
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
Highlighted
Champion III
Champion III

‌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

try this

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

Highlighted
Master II
Master II

Hi Vishal,

try this:

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


Br,

KC

Best Regards,
KC
Highlighted
Creator
Creator

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

value should be in double quotes.

Highlighted
Creator III
Creator III

Thanks all for the reply

How to avoid these ST category in dimension as well.

Highlighted
Master
Master

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