topic Re: Expression total is giving wrong value in QlikView

Expression total is giving wrong value

vipingarg23 — Fri, 28 Jul 2017 13:30:04 GMT

Hi All,

When I am calculating the percentage of red marked column by expression total, it is giving me the wrong data. Can anybody help me ?

Re: Expression total is giving wrong value

sunny_talwar — Fri, 28 Jul 2017 15:19:29 GMT

What is your expression? What all are your dimensions? and what is the expected output?

Re: Expression total is giving wrong value

vipingarg23 — Fri, 28 Jul 2017 16:16:49 GMT

Expression is (column1/column2) and expected output that I am looking for, is - (Sum(Column1)/Sum(Column2))*100 means percentage.

and there are lots of dimensions.

Re: Expression total is giving wrong value

sunny_talwar — Fri, 28 Jul 2017 16:24:01 GMT

Hahahaha your response didn't really answer any of my question in a way that I can offer help.... Anyways, would you be able to share a sample?

Re: Expression total is giving wrong value

vipingarg23 — Sat, 29 Jul 2017 06:13:33 GMT

Here A,B,C are expressions and I am calculating the Value of A and B from other fields. And calculating the value of C through formula - B/A. Now when I am doing expression total for all expression A,B,C, I am getting the right value of A,B but I am not getting the right value of C where I am calculating the percent. So I am expecting output Sum(B)/Sum(A)*100 means - 194/247*100=78.54%....I am getting the value 194,247 but not 78.54..It is giving me something else.

Re: Expression total is giving wrong value

neha_shirsath — Sat, 29 Jul 2017 06:34:25 GMT

If you are using straight table then go to expression tab and check for Expression total.

Re: Expression total is giving wrong value

vipingarg23 — Sat, 29 Jul 2017 06:51:18 GMT

Yes, I am using straight table and doing the same but it is not working.

Re: Expression total is giving wrong value

vinieme12 — Sat, 29 Jul 2017 08:59:54 GMT

There is a difference between Expression TOTAL and Sum of ROWS

try this sample data

LOAD * INLINE [

DIM, C1, C2

A, 10, -10

B, 15, -60

C, 17, 12

D, 26, -13

E, 65, 10

];

Create a straight table with All 3 fields in dimensions

2 same Expressions i.e. =C1 /C2

Expression 1 to have : Expression TOTAL

Expression 2 to have Sum of ROWS

This should help you understand the difference

Look at the TOTAL mode section, Bottom right hand side

Re: Expression total is giving wrong value

sonkumamon — Sat, 29 Jul 2017 09:23:05 GMT

I don't understand, do you want to total row to sum all the percentage values in the field or do you want it to present the Sum of field 1 divided by the sum of field 2?

Maybe you can give a more clear presentation of your data?

Re: Expression total is giving wrong value

vinieme12 — Sat, 29 Jul 2017 18:41:09 GMT

please post your app!

Re: Expression total is giving wrong value

vinieme12 — Sat, 29 Jul 2017 18:44:19 GMT

Also i don't think you can use Aggregation functions with column references!!

as you said A and B are expressions which means they have aggregations functions like sum,min or max

so Sum(A) or Sum(B) will never work!

To have Expression totals you need an aggregation function so i suggest you rewrite the expression for A and B

C = Full expression for B / Full expression for A * 100

Re: Expression total is giving wrong value

vipingarg23 — Sun, 30 Jul 2017 08:59:02 GMT

Yes...It is working for me..Thanks for your help.