Set analysis with exclude condition

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

Hi Experts,

Can anyone please help me on below set analysis expression.

=Count({<[RAG]={'R'},{Metric Group}={'Entertainment'},[Metric]-={" '-' "},Group-={" ' ' -"},[Sub Group] -= {" ' - ' "}>}[RAG ind])

Thanks in advance.

Re: Set analysis with exclude condition

jonathandienst — Thu, 02 Nov 2017 04:51:51 GMT

>> Already from Metric Group I have Included {'Entertainment'} also from the same field need to exclude the null [Metric Group]-={"'-'"}.

Selecting Entertainment will automatically exclude the nulls.

>>=Count({<[RAG]={'R'},{Metric Group}={'Entertainment'},[Metric Group]-={"'-'"},[Metric]-={" '-' "},Group-={" ' ' -"},[Sub Group] -= {" ' - ' "}>}[RAG ind])

The second reference to the Metric Group will override the first and you have curly braces in the wrong position. To exclude null values, use

Count({<RAG = {'R'}, [Metric Group] = {'Entertainment'}, Metric = {'*'}, Group = {'*'}, [Sub Group] = {'*'}>} [RAG ind])

topic Re: Set analysis with exclude condition in QlikView

Set analysis with exclude condition

Re: Set analysis with exclude condition