topic How to write expression using sum function in calculated dimension. in QlikView

How to write expression using sum function in calculated dimension.

Fri, 06 Apr 2012 10:32:19 GMT

Hello everyone,

I'm new to Qlik View.

I'd like to show "sum by project" in calculated dimension of the chart.

My current setting is as follows;

sum(total<project> amount)

But it doesn't work.

Does anyone help me ?

Haruko.S

Re: How to write expression using sum function in calculated dimension.

jagannalla — Fri, 06 Apr 2012 11:02:09 GMT

I tried with sample data it is working. Instead of Straight table you can using pivot table also. Here i'm attaching sample qvw file please check it.

How to write expression using sum function in calculated dimension.

CELAMBARASAN — Fri, 06 Apr 2012 11:07:03 GMT

Hi,

Instead you can try using Pivot chart with sub total option for the project dimension(which you found under the presentation tab)?

Celambarasan

How to write expression using sum function in calculated dimension.

Fri, 06 Apr 2012 12:20:07 GMT

Thanx for the quick reply.

But it's a bit different what I really wanna do becuz of my explanation is bad.

Please see the below.

The 3rd column enclosed with red line is project.

The 6th column also enclosed with red line is amount.

Project #0023395 is liked to 2 orders because there are 2 rows.

I'd like to merge those 2 rows into 1 row and show total amount by project there with setting some expression in dimension panel of the chart property dialog. (see the below)

Re: How to write expression using sum function in calculated dimension.

jagannalla — Fri, 06 Apr 2012 13:31:18 GMT

i didn't get what u r saying..