topic Re: Set Expression Help in QlikView

Set Expression Help

djfrear — Sat, 16 Nov 2024 03:22:41 GMT

Hi,

I'm struggling to work out why this doesn't work as expected:

Count({<[IsDeleted]-={1},[IsAccepted]={1}>} [JobId-ID])

My intention is to count the JobId-ID field if "IsAccepted" is set to 1 but whilst ignoring anything where "IsDeleted" is set to

Could anyone help me as to what I'm just not understanding here? Logically it feels right, but the result does not change after adding the "IsDeleted" section

Regards, Daniel

Re: Set Expression Help

MindaugasBacius — Thu, 06 Jun 2019 11:08:08 GMT

Count({<[IsDeleted],[IsAccepted]={1}>} [JobId-ID])

Try the above please.

In seat analysis to ignore the dimensions selection simply include it into the {<...>}.

Re: Set Expression Help

djfrear — Thu, 06 Jun 2019 11:14:32 GMT

Thanks - that pointed me in the right direction. It's a data issue rather than a query issue!