topic error in calculated dimension in QlikView

error in calculated dimension

Thu, 31 Mar 2011 11:39:13 GMT

Hi,

I need a calculated dimension that goes like this:

=if(count(Aggr(max({<LS_STATUS={'VL'}>}doorlooptijd2),SLEUTEL))=0,"SLEUTEL")

But I'm getting an "Error in calculated dimension".

I also tried

=if(count({<LS_STATUS={'VL'}>}Aggr(max({<LS_STATUS={'VL'}>}doorlooptijd2),SLEUTEL))=0,"SLEUTEL")

But that also doesn't work...

Anyone knows what the problem is?

Thanks in advance.

error in calculated dimension

Anonymous — Thu, 31 Mar 2011 11:43:08 GMT

In these cases it is often the aggr combined with other functions which gives the 'error in calculated dimension' ...

don't have the solution here for you ... but try to build the thing up step-by step to see what is giving the error.

error in calculated dimension

Thu, 31 Mar 2011 12:23:29 GMT

Maybe a bit more info on what i'm trying to do.

I have records with TurnAroundTimes.

SLEUTEL = KEY

PLANUITVOERING = START

LS_INSERTDATE = END

doorlooptijd2 = TAT

LS_STATUS = every time the status changes, there is a new TAT added

So now i need to show a table of only the records with SLEUTEL that don't have a value 'LV' in the status field.

Like the one on the image in the red square (SLEUTEL = 2452029), this ons has 4 records, but none of these records have a status 'VL'.

error in calculated dimension

Thu, 31 Mar 2011 12:34:56 GMT

Hi,

If you remove the count and go with Aggr, it will work. Not sure about you will get desired output.

=if(count(Aggr(max({<LS_STATUS={'VL'}>}doorlooptijd2),SLEUTEL))=0,"SLEUTEL")

error in calculated dimension

Fri, 01 Apr 2011 08:57:52 GMT

I've found a way to make it work.

In my script I've created a new field (STATUS_VL) for every record, that evaluates if the status = VL, then the field gets the value 1, else it gets the value 0.

Then I changed my calculate dimension to

=if(Aggr(sum(STATUS_VL),SLEUTEL)=0,SLEUTEL)

and it works! 🙂