Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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
TigerisBack
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)

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 ?

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

View solution in original post