topic Re: How to use difference(Substraction) in calculated dimenssion? in QlikView

Can anyone solve this---(How to use difference(Substraction) in calculated dimenssion)?

Mon, 06 Aug 2012 15:29:24 GMT

Hi All,

I have a dimenssion(Q8-Q1) which I want to modify as below:

Dimenssion	A-B	A/B
Q8	12	50%
Q7	24	29%
Q6	25	94%
Q5	7	52%
Q4	64	94%
Q3	44	12%
Q2	35	33%
Q1	43	73%
*Q5-Q1*	*-36*	*-21%*

the last row showing difference of Q5 and Q1.

I have fields as A and B, and what you can see here (A-B, A/B) are calculated metrices. So, like A-B and A/B there are 20 others.

Why I am telling you the above things is b'coz i dont want to write expressions 9 times(Q8, Q7....Q1, Q5-Q1) for each calculated metric(A-B).

If anyone has any idea plzz let me know, any sort of help will be highly appreciated.

Thanks

Sagar Gupta

Re: How to use difference(Substraction) in calculated dimenssion?

suniljain — Tue, 07 Aug 2012 07:42:47 GMT

can you provides details of business req on Q5-q1 ?. what will be other requires expression ?.

Re: How to use difference(Substraction) in calculated dimenssion?

Tue, 07 Aug 2012 07:52:51 GMT

Hi Sunil,

You don't worry about rest of the expressions as it will be the same more or less, the only thing i want is to show Q5-Q1 values for all my calculated metrices.

It will be much better if you can be in my skype frnd list.

Regards

Sagar Gupta

7411502937

Re: How to use difference(Substraction) in calculated dimenssion?

Tue, 07 Aug 2012 08:10:08 GMT

check this (island table + calculated dimension)

*** expressions i made need to be rebuild to be correct (i just show an idea)

Re: How to use difference(Substraction) in calculated dimenssion?

Tue, 07 Aug 2012 09:52:07 GMT

Hi Pari,

Thanks for the reply.....

You have changed the expression according to my requirement, but i don't to change my expression coz' i have lot many. Is there any other way by which I can get the values without hard coding in the expression. Please tell me how can I write the calculate dimenssion so that the values will be automatically pulled for (Q5-Q1).

Regards

Sagar Gupta

Re: How to use difference(Substraction) in calculated dimenssion?

sivarajs — Tue, 07 Aug 2012 10:52:31 GMT

Try this expression

below(Sum(Field)-Sum(Field)

Re: How to use difference(Substraction) in calculated dimenssion?

Tue, 07 Aug 2012 11:14:46 GMT

Hi Sivaraj,

I guess you misunderstood my requirement, I am explaining you again what I am looking for.

All my metrics will show the values for respective quarters(Q1-Q8), now I want my dimenssion to be as below:

Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q5 - Q1. the newly added Q5-Q1 should not only display in the table also it

6 5 3 7 9 4 7 2 3

should give values as well.

Still if you are not clear then plz check for the sample file which i uploaded in the start of the post.

Any help will be highly appreciated

Regards

Sagar Gupta

Re: How to use difference(Substraction) in calculated dimenssion?

Tue, 07 Aug 2012 11:25:07 GMT

Hi Sivaraj,

Just wanted to know that calculated dimenssion of this kind will work or not( some modifications required)

if(Quarter_ID<>'Q9', Quarter_ID, Quarter_ID=('Q5' - 'Q1'))

Regards

Sagar Gupta

Re: How to use difference(Substraction) in calculated dimenssion?

sivarajs — Tue, 07 Aug 2012 12:04:48 GMT

if(Quarter_ID<>'Q9', Quarter_ID, Quarter_ID=('Q5' - 'Q1')) It wont assign 'Q5' - 'Q1' to that field but then following will display

if(Quarter_ID<>'Q9', Quarter_ID, 'Q5' - 'Q1')

Re: How to use difference(Substraction) in calculated dimenssion?

Tue, 07 Aug 2012 12:09:39 GMT

Hi,

Ya i know, my moto is not only to display(Q5-Q1) but also to make it functional, so that i dont have to hard code my Expressions.

What you have mentioned above will only display(Q5-Q1) and it won't be giving values for Q5-Q1

Regards

Sagar Gupta