topic Re: Count If Set Analysis in QlikView

Count If Set Analysis

khaycock — Sat, 16 Nov 2024 04:45:27 GMT

I have an expression that I am trying to combine set anaylsis and a count if, but I can't seem to get the combination right. These are the two separate expressions that I am trying to combine:

=Count({<PART_NUMBER-={"''"}>}NEED_BY_DATE)

=count(if(NEED_BY_DATE < date(today()),0))

Any ideas?

Re: Count If Set Analysis

agigliotti — Tue, 15 Jan 2019 11:21:57 GMT

maybe this:
=Count( {< PART_NUMBER -= {"''"} >} if( NEED_BY_DATE >= date(today()), NEED_BY_DATE ) )
Regards

Re: Count If Set Analysis

its_anandrjs — Tue, 15 Jan 2019 12:03:48 GMT

Hi,

You can try this also with complete SET analysis statement

=Count( {< PART_NUMBER -= {"''"}, NEED_BY_DATE ={">=$(=date(today( )) )"} >} NEED_BY_DATE )

Regards,

Anand