topic Class funcion in calculated dimension in QlikView

Class funcion in calculated dimension

Sat, 17 Mar 2012 10:56:55 GMT

Hi All,

I am looking for a solution to solve this.

should work with the class function but no idea how to.

Any idea (see attached example)

total beds needed x times occured

3 1x

4 1x

5 1x

many thanks in advance!!

Sat, 17 Mar 2012 20:26:50 GMT

Hi Mavan,

I think you should do it in the script first:

Left Join

LOAD

count(DISTINCT Patientnr) as CountNum

Resident a

Group by Datum;

wnd then the dimmension will be:

=class(CountNum, 1, 'X')

See the attached,

Hope it help.

Sat, 17 Mar 2012 20:39:38 GMT

Thanks works perfect.

In addition this is also working

=aggr(class(count(distinct Patientnr),1),Datum) with the expression count (distinct Datum)