Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Re: Count Function

No, it is a count of 0

pradosh_thakur
Honored Contributor II

Re: Count Function

hi stalwar1

can you please point out the error in my expression ?

regards

Pradosh

Learning never stops.

Re: Count Function

There is small mistake, That may be the cause. Can you trouble shoot to use " " instead of [ ]

Life is so rich, and we need to respect to the life !!!
Not applicable

Re: Count Function

Capture 1.PNGCapture.PNG

Not applicable

Re: Count Function

Thank you everyone.

The correct answer I found is

Sum (if( Aggr( [EXPIRATION] - [ASSET MODIFIED DATE.autoCalendar.MonthsAgo] , [ASSET TITLE]  )  >= 6 , 1, 0 ))

Which is borrowed from a previous question's answer. I am now having trouble adapting this for the values that fall between numbers. So now, I need a count of those between 0 and 3. Can't get the formatting right.

Re: Count Function

Just this

Sum(If(

Aggr([EXPIRATION] - [ASSET MODIFIED DATE.autoCalendar.MonthsAgo] , [ASSET TITLE]) >= 0 and

Aggr([EXPIRATION] - [ASSET MODIFIED DATE.autoCalendar.MonthsAgo] , [ASSET TITLE]) <= 3, 1, 0))

Highlighted
Not applicable

Re: Count Function

You rock! Thank you.

Community Browser