topic Calculated Dimension in QlikView

Calculated Dimension

Anonymous — Wed, 17 Feb 2010 17:44:25 GMT

Hi All

I have a very simple question for Calculated Dimension.

I have a field in which I have values starting from 1 to 50

I want to calculate dimensions to categorise these values like below

1 day

5 to 10 days

10 to 15 days

15 to 20 days

greater than 20 days

I am using the following script.

=if([Length of stay]=1,'1 day',
if([Length of stay]>1 and [Length of stay]<=5,'2 to 5 days',
if([Length of stay]>5 and [Length of stay]<=10,'6 to 10 days',
if([Length of stay]>10 and [Length of stay]<=15,'11 to 15 days',
if([Length of stay]>15 and [Length of stay]<=20,'16 to 15 days',
if([Length of stay]>21,'greater than 21 days','other'))))))

I think this is working fine but my legend is showing me this code and when i hover over chart I am also seeing this code I want to see the numbers instead of code

Cananyone help me please?

Many thanks in advance

Regards,

Waqas

Calculated Dimension

Wed, 17 Feb 2010 18:22:50 GMT

If you add a label to the calculated dimension, you will then not see the expression and see the label

Calculated Dimension

johnw — Wed, 17 Feb 2010 22:32:42 GMT

A little off topic, but since the IF statements are checked in sequence, you can simplify:

=if([Length of stay] = 1, '1 day',
if([Length of stay]<= 5, '2 to 5 days',
if([Length of stay]<=10, '6 to 10 days',
if([Length of stay]<=15,'11 to 15 days',
if([Length of stay]<=20,'16 to 20 days',
if([Length of stay]> 21,'greater than 21 days'
,'other'))))))

You might also be better off moving this expression into your script, establishing a [Length of Stay Group] or some such. That would also incidentally fix your original problem.

Calculated Dimension

disqr_rm — Wed, 17 Feb 2010 22:39:22 GMT

You should be able to use class() function in the script to calculate this field.

In any case, as John said, you would be better off moving this code to your script.

Calculated Dimension

johnw — Wed, 17 Feb 2010 22:59:20 GMT


Rakesh wrote:You should be able to use class() function in the script to calculate this field.

Except that the intervals aren't even. Some of them are, but not all.

Calculated Dimension

Anonymous — Thu, 18 Feb 2010 11:12:34 GMT

Thak you so much Neil, John and Rakesh.

At the moment i have fixed this problem as Neil suggested but i would like to know how can I move this to my script, as I know when the data grows calculated dimension is not a good idea. John can you please help me with this?

Rakesh can you please tell me about Class function? how is works with the help of an example. I want to learn it.

Many thanks in advance.

Regards,

Waqas

Calculated Dimension

Anonymous — Thu, 18 Feb 2010 12:53:57 GMT

Hi all again

I used John's post to move my If statement to script - working perfectly fine 😉

here is the link

http://community.qlik.com/forums/p/22135/84583.aspx#84583

I am still waiting for the Class function though

Cheers

Waqas

Calculated Dimension

disqr_rm — Thu, 18 Feb 2010 17:24:50 GMT

Enclosed is an example of Class. Pretty useful, but only if you have equal rage values.

Calculated Dimension

Anonymous — Fri, 19 Feb 2010 10:43:51 GMT

Thank you so much Rakesh. It was indeed very helpful.

Kind Regards,

Waqas