Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mirlogic
New Contributor II

Count expression disregarding filters

I have a data set that spans multiple years and i need an expression that ignores any filters, but i need to apply conditions to the entire data set.

this expression works with the filter, but i need to applly this across the entire dataset

Count(If((Mid([PIID], 10, 1) <> 'G')

and ([Base And Alloptions Amnt] > 500000 and [Base And Alloptions Amnt] <=2500000)

and ([Mod Number] = 0)

and ([Contr Office ID] <> left ([RefIDV PIID], 6)), [Contr Office ID]))

1 Solution

Accepted Solutions
MVP
MVP

Re: Count expression disregarding filters

May be this

Count({1} If((Mid([PIID], 10, 1) <> 'G')

and ([Base And Alloptions Amnt] > 500000 and [Base And Alloptions Amnt] <=2500000)

and ([Mod Number] = 0)

and ([Contr Office ID] <> left ([RefIDV PIID], 6)), [Contr Office ID]))

3 Replies
MVP
MVP

Re: Count expression disregarding filters

May be this

Count({1} If((Mid([PIID], 10, 1) <> 'G')

and ([Base And Alloptions Amnt] > 500000 and [Base And Alloptions Amnt] <=2500000)

and ([Mod Number] = 0)

and ([Contr Office ID] <> left ([RefIDV PIID], 6)), [Contr Office ID]))

agigliotti
Honored Contributor II

Re: Count expression disregarding filters

maybe this:

Count( {1} If((Mid([PIID], 10, 1) <> 'G')

and ([Base And Alloptions Amnt] > 500000 and [Base And Alloptions Amnt] <=2500000)

and ([Mod Number] = 0)

and ([Contr Office ID] <> left ([RefIDV PIID], 6)), [Contr Office ID]))

mirlogic
New Contributor II

Re: Count expression disregarding filters

Again you ROCK!

Community Browser