topic Re: Set Expression Problem in QlikView

Set Expression Problem

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

I've ISSUE_IDs that I want to count the distinct number where the ISSUE_ID = 0 AND is not a member of a list of fuel types.

Here's what I've got so far, and just returns "Error in Expression"

=COUNT({<CLOSED_ISSUE={"0"}, UNIT_FUEL_TYPE -={"PROPANE", "GAS, "CNG", "DIESEL"}>} DISTINCT ISSUE_ID)

Is this even remotely close to the right syntax?

Full disclosure: these set expressions are something still not really all that great at...

Thanks in advance for any guidance.

~Jonathan

vishsaggi — Fri, 15 Jun 2018 16:16:39 GMT

Try this?

= COUNT({< CLOSED_ISSUE = {0}, UNIT_FUEL_TYPE -={'PROPANE', 'GAS', 'CNG, 'DIESEL'} >} DISTINCT ISSUE_ID)

Colin-Albert — Fri, 15 Jun 2018 16:19:37 GMT

Hi Jonathon,

Double quotes should be used to contain search expressions in set analysis, single quotes should be used to define text.

there is no need for quotes around numbers.

=COUNT({<CLOSED_ISSUE={0}, UNIT_FUEL_TYPE -={'PROPANE', 'GAS', 'CNG', 'DIESEL'}>} DISTINCT ISSUE_ID)

The difference between single and double quotes has not always been applied.

schneider2037 — Fri, 15 Jun 2018 16:20:32 GMT

HHmm. Nope. CLOSED_ISSUE is definitely text "1" or text "0" (don't ask...I inherited)...drat.

vishsaggi — Fri, 15 Jun 2018 16:33:09 GMT

So just use like {'0'}

MarcoWedel — Fri, 15 Jun 2018 20:19:41 GMT

missing double quotes after GAS

schneider2037 — Mon, 18 Jun 2018 10:55:19 GMT

doh!