Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis Select in DIM 1 and Exclude DIM 2 and Calculate DIM 3

I want calculate the number of Action Plan when the risk is relevant and have assigned group, if the group is equal to null exclude it from the account

I have this sentence....

=Count(DISTINCT{<[Nivel de Riesgo]={'Relevante'}>}Action Plan)

and a want Exclude in "Grupo" the null data

select like this

[Nivel de Riesgo] = 'Relevante'

Grupo = ' ' (NULL)

1 Solution

Accepted Solutions
MayilVahanan

Hi,

     Try this,

          =Count(DISTINCT{<[Nivel de Riesgo]={'Relevante'}, Grupo -={''}>}Action Plan)

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

Hi,

     Try this,

          =Count(DISTINCT{<[Nivel de Riesgo]={'Relevante'}, Grupo -={''}>}Action Plan)

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

Mayil Vahanan Ramasamy escribió:

Hi,

     Try this,

          =Count(DISTINCT{<[Nivel de Riesgo]={'Relevante'}, Grupo -={''}>}Action Plan)

     Hope it helps

HI Mayil

Thanks for the reply,
I have a question about the answer....
why highlighted in red because it appears as if it were a mistake and because the sign of - and + does the same? can you give me a little explanation ..