topic Re: Count If with Multiple Conditions in QlikView

Count If with Multiple Conditions

Anonymous — Tue, 01 May 2018 11:48:38 GMT

Hi,

Newbie to QV. I have the following expression for a chart; but I keep getting "Error in set modifier expression"

COUNT ({< [Issue ID]= {'Pending Issue ID'}, (((Date(now(),'MM/DD/YYYY')) - Date([Report Date], 'MM/DD/YYYY')) = {"<100"}) >} [Issue ID] )

Help! Thanks in advance.

Re: Count If with Multiple Conditions

vishsaggi — Tue, 01 May 2018 15:52:23 GMT

you cannot use

(((Date(now(),'MM/DD/YYYY')) - Date([Report Date], 'MM/DD/YYYY')) = {"<100"})

like this in your set. Can you elaborate what exactly you are trying to filter here for <100.

Re: Count If with Multiple Conditions

vishsaggi — Tue, 01 May 2018 16:14:24 GMT

may be one way you can do like below

CntCheck:
LOAD *, Num(Date(Today(),'MM/DD/YYYY') - Date(ReportDate, 'MM/DD/YYYY'), '#,##0') AS ReportDays;
LOAD *, Date(Date#(DateReported, 'MM/DD/YYYY'),'MM/DD/YYYY') AS ReportDate;
LOAD ISSUE ID, DateReported

FROM YOURSOURCE;

Then you can use like

= COUNT ({< [Issue ID]= {'Pending Issue ID'}, ReportDays = {'<100'}) >} [Issue ID] )

This is a dummy sample I made.

= Count({< ID = {2}, ReportDays = {'<100'} >} ID)

Re: Count If with Multiple Conditions

Digvijay_Singh — Tue, 01 May 2018 16:20:37 GMT

You may try this -

COUNT ({< [Issue ID]= {'Pending Issue ID'}>*<[Issue ID]={"=Date(floor(today()),'MM/DD/YYYY') - Date([Report Date], 'MM/DD/YYYY')) <100"} >} [Issue ID] )

Re: Count If with Multiple Conditions

Anonymous — Tue, 01 May 2018 16:55:06 GMT

Thank you! It worked!!