Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to write expression using sum function in calculated dimension.

Hello everyone,

I'm new to Qlik View.

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

example.JPG

My current setting is as follows;

sum(total<project> amount)

But it doesn't work.

Does anyone help me ?

Haruko.S

4 Replies
jagannalla
Partner
Partner

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.

CELAMBARASAN
Partner
Partner

Hi,

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

Celambarasan

Not applicable
Author

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.

ex.JPG

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)

ex2.JPG

jagannalla
Partner
Partner

i didn't get what u r saying..