Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

baarathi
Contributor II

How to exclude a range of values

= Count({<Amount = {">0"}, A = {"0*"} , A -= {"0000*"}>}Id) , will this method exclude values 0000# and include 0# ?

Tags (1)
5 Replies
YoussefBelloum
Esteemed Contributor

Re: How to exclude a range of values

Try this:

=Count( {<Amount = {">0"}, A= {"0*"}-{"0000*"}>}  Id)

devarasu07
Honored Contributor II

Re: How to exclude a range of values

Hi,

expression looks ok & what is the issue ? can you share the mock data and expected output? Thanks

vinieme12
Esteemed Contributor II

Re: How to exclude a range of values

yes, try it urself

vinieme12
Esteemed Contributor II

Re: How to exclude a range of values

try with below

LOAD * inline [

A

0001

111

222

00002   <<excluded as per pattern  A -= {"0000*"}

03       <<included as per A = {"0*"}

];

Count({<A = {"0*"} , A -= {"0000*"}>}A)

baarathi
Contributor II

Re: How to exclude a range of values

I am not getting the desired result, beacuse i want to get the count of id, grouping by id and date(if a same id is present in same date n times it should be considered as 1 count) whereas the same id can be in n different dates, then the count is n.

Community Browser