topic Re: Write a calculated dimension in QlikView

Write a calculated dimension

Mon, 28 Jul 2014 06:28:52 GMT

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

whiteline — Mon, 28 Jul 2014 06:33:19 GMT

Hi.

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

Mon, 28 Jul 2014 06:46:00 GMT

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

Mon, 28 Jul 2014 06:54:04 GMT

Hi,

Can You upload sample data ?

SunilChauhan — Mon, 28 Jul 2014 06:54:13 GMT

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)