Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

exclude 3 dimensions in an expression

Hello evryone,

I would like to do a count for an ID and I want to exclude 3 dimensions in my expression, how to do it?

=count({<dimension1 = , dimension2 => ID_field} ==> it work well. But how to add my third dimension in this expression?

If that is not possible, how to exclude 3 dimensions in an expression?

Thank you for your help...

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

Hi,

You can exclude as many expressions as you want. The expression is more like this:

count({<dimension1 = , dimension2 = , dimension3 = >}  ID_field )

Regards,

Erich

View solution in original post

3 Replies
erichshiino
Partner - Master
Partner - Master

Hi,

You can exclude as many expressions as you want. The expression is more like this:

count({<dimension1 = , dimension2 = , dimension3 = >}  ID_field )

Regards,

Erich

Not applicable
Author

Thank you Erich, I tried but it doesn't work...

Apparently, it takes at most only 2 dimensions.

Mouhsine

Not applicable
Author

Hi Erich,

You're right. But it must respect uppercase lowercase Even if QV puts an error highlighted in red.

Thanks Erich...

See you.

Mouhsine