topic Re: Count With Multiple Conditions in QlikView

Count With Multiple Conditions

gfisch13 — Fri, 15 Nov 2024 23:51:46 GMT

Hi - I've been working with the following expression and I cannot seem to get the syntax correct. I'm getting an error on the second half of the statement (highlighted): Error in set modifier expression. I'm not totally understanding what I'm doing wrong. Any help is appreciated.....certainly, if there is a better way to accomplish this I'm all ears. Thanks! George

(count({$<[QuarterYearReceived]<=[QuarterYearClosed]>}), ICMSCaseStatus={'Closed'}>} [ICMSCaseNumber]))

Re: Count With Multiple Conditions

Vegar — Mon, 05 Oct 2020 20:09:47 GMT

Your red modifier looks fine. I think your issue lies within the first part of your expression.

Firstly you are closing the set expression before the red part comes in. Secondly the set below is not a valid set as you cant do <= comparisons as you have done.

{$<[QuarterYearReceived]<=[QuarterYearClosed]>})

Re: Count With Multiple Conditions

Taoufiq_Zarra — Mon, 05 Oct 2020 20:11:07 GMT

@gfisch13 like ?

if([QuarterYearReceived]<=[QuarterYearClosed],count({<ICMSCaseStatus={'Closed'}>} [ICMSCaseNumber]))

Re: Count With Multiple Conditions

Kushal_Chawda — Mon, 05 Oct 2020 21:48:40 GMT

@gfisch13 try below

(count({$<[QuarterYearReceived]={"=[QuarterYearReceived]<=[QuarterYearClosed]"}, ICMSCaseStatus={'Closed'}>} [ICMSCaseNumber]))

Re: Count With Multiple Conditions

gfisch13 — Tue, 06 Oct 2020 11:58:37 GMT

Thank you all for your input!!!