Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Master II
Master II

Hi.

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

Highlighted
Not applicable

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

Highlighted
Not applicable

Hi,

Can You upload  sample data ?

Highlighted
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