topic SET ANALYSIS - COUNTIF in QlikView

SET ANALYSIS - COUNTIF

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

Please assist with the syntax for the set analysis.

I want to do a count if DATE1>DATE2 and COUNT the number field.

Thus,

=Count({DATE1>=DATE2}[NUMBER])

Thanks in advance.

Re: SET ANALYSIS - COUNTIF

Anil_Babu_Samineni — Mon, 27 Jun 2016 09:52:47 GMT

=count({$<DATE1 = {">DATE2"}>}number)

Re: SET ANALYSIS - COUNTIF

Mon, 27 Jun 2016 09:59:02 GMT

Hi,

Set analysis could be used for filtering the records, it can be used to filter the records for certain range of dates it could not compare. you can use simple if function .

Re: SET ANALYSIS - COUNTIF

tyagishaila — Mon, 27 Jun 2016 10:03:47 GMT

Hope it will work,

Count({<Date1 = {">=$(Date1)"}>}Number)

Re: SET ANALYSIS - COUNTIF

tresB — Mon, 27 Jun 2016 10:05:49 GMT

Try like:

=Count({<DATE1={"=DATE1>=DATE2"}>}[NUMBER])

Make sure that DATE1 and DATE2 have similar date formats.

Re: SET ANALYSIS - COUNTIF

muthukumar77 — Mon, 27 Jun 2016 11:25:06 GMT

Hi,

Refer this App.