topic Re: Calculated columns in pivot table in QlikView

Calculated columns in pivot table

Mon, 13 Aug 2012 07:49:41 GMT

Hello,

I need your help to define a calculated expression between columns depending columns values. What I want to do it's Age0/AgeDN, Age1/AgeDN...

I have a pivot table like that :

Two dimensions : Year (2010, 2011, 2012) and AGE (DN, 0, 1, 2, 3, 4...)

One expression : SUM(VAL)

YEAR	DN	0	1	2	3	4
2010	150 000	1	0	3	2	1
2011	20 000	2	10	2	1	1
2012	140 000	50	2	1	0	1
...

What I want it's to calculate an expression which give me this result

How can I do that ?

Thank you for your help.

Sokkorn — Mon, 13 Aug 2012 07:57:04 GMT

Hi kiks51,

Can you share your app with sample data?

Regards,

Sokkorn

kouroshkarimi — Mon, 13 Aug 2012 08:14:47 GMT

=if(age='DN',sum(VAL),sum(VAL) & '/' & first(sum({<age={'DN'}>}VAL),1,0))

Edit:

Based on your example file:

=if(TEV_AGE='DN',sum(TEV_VAL),sum(TEV_VAL) & '/' & first(sum({<TEV_AGE={'DN'}>}TEV_VAL),2,0))

Tue, 14 Aug 2012 05:49:49 GMT

Thank you for your answer ! It works well. I've changed a little the expression because I wanted to evaluated the division. I didn't clearly express.

But now I have an other problem, it's how represent the same thing in a graph, how can I do that ?