Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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