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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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