topic Problem with calculated dimension in QlikView

Problem with calculated dimension

timmy — Thu, 11 Feb 2010 14:48:09 GMT

Hey,

I have a pivot table with a calculated dimension:

This is my formula.

=if(not Dos_Active,Stat_DosStatusId & ' ' & DosStatusOmsNL,null())

the problem that i have is that i have to many records and this formula slows down the loading of the pivot every time i make a new selection

Can anybody help me?

tnx

Problem with calculated dimension

Thu, 11 Feb 2010 15:13:59 GMT

Hi Timmy,

create the dimension in your qlikview script.

Is this an option for you?

Rainer

Problem with calculated dimension

timmy — Thu, 11 Feb 2010 15:19:43 GMT

It's no option for the moment! We can't get the data and we need to improve the perfomance of this pivot...

But tnx for the answer

Problem with calculated dimension

johnw — Fri, 12 Feb 2010 00:08:30 GMT

Some brief testing of mine recently seemed to indicate that conditions in a calculated dimension ran about ten times more slowly than conditions in the chart. I have no explanation why, it was just what I was seeing for a simple example, and was consistent across versions 8.5 and 9.0 SR2.

Assuming that's part of the problem, you might just use this for your calculated dimension:

Stat_DosStatusId & ' ' & DosStatusOmsNL

And then move the condition to the chart expression(s):

if(not Dos_Active,sum(Something))

And then suppress null expressions. Might help, might not, but probably worth a try. If it does help, I have no explanation for why it would help.

I do think that creating the dimension in the script is a better plan, but I can understand if you need a solution NOW, and can't change the script right now.

Problem with calculated dimension

timmy — Fri, 12 Feb 2010 00:24:31 GMT

This will help!

Only the surpress null()

tnx allot

Problem with calculated dimension

blaise — Fri, 12 Feb 2010 00:43:19 GMT

Calculated dimension are one of a few functions in Qv that just doesn't seems to be fully functional / developed / tested / optimized. Always trying to avoid them (mainly because the lack of sort by expression)

Problem with calculated dimension

Wed, 17 Feb 2010 12:01:53 GMT

Yeah, calculated dimensions are annoying. I wonder when QV will fully implement it and also fix the sorting bug.

Problem with calculated dimension

Wed, 17 Feb 2010 12:23:01 GMT

You should always be able to to get the calculated dimension sorted in the right order.... If the expression is really complex breakand all else fails concatenate a number or letter so that it is presented in the correct order using text or numeric sort.