Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Write a calculated dimension

I would like to have the next as a calculated dimension:

=class(count(DISTINCT emptyings_id),20)

and the one below as expression:

count(DISTINCT emptyings_id

The idea is to make a graph where the % count of emptyins_id is shown in a certain class.

The calculated dimension however gives a calcutation error.

How do I write this correctly?

Kind regards,

Katleen

1 Solution

Accepted Solutions
SunilChauhan
Champion
Champion

as you are using aggregation function (count) thats y its showing error. you could use with aggr

like below



class(aggr(count(DISTINCT emptyings_id),emptyings_id),20)

Sunil Chauhan

View solution in original post

4 Replies
whiteline
Master II
Master II

Hi.

You should use aggr() function to build calculated dimension.

Not applicable
Author

Can you give me a little hint how to make this into an aggregated expression?

Not applicable
Author

Hi,

Can You upload  sample data ?

SunilChauhan
Champion
Champion

as you are using aggregation function (count) thats y its showing error. you could use with aggr

like below



class(aggr(count(DISTINCT emptyings_id),emptyings_id),20)

Sunil Chauhan