Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Set analysis with exclude condition

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.

1 Reply

>> 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])

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein