topic Generate expression for calculated values in QlikView

Generate expression for calculated values

agni_gold — Sat, 22 Aug 2015 17:35:51 GMT

Hi All ,

I have two table

Account

Now I have loaded these tables , And Created one pivot table ,

Here value of C=A+B

For this i have written expression ,

if(Account='C',Sum({<Account={'A'}>}Value)+Sum({<Account={'B'}>}Value),Sum(Value))

But it is not showing value for C

Please help , attaching my sample application

maxgro — Sat, 22 Aug 2015 17:49:15 GMT

maybe with a total

if(Account='C',Sum({<Account={'A'}>}total Value)+Sum({<Account={'B'}>}total Value),Sum(Value))

petter — Sat, 22 Aug 2015 17:49:50 GMT

You could change the expression to this:

if(Account='C',Sum(TOTAL {<Account={'A'}>} Value) + Sum(TOTAL {<Account={'B'}>} Value),Sum(Value))

agni_gold — Sat, 22 Aug 2015 18:34:52 GMT

Here is my situation ,

In attached excel , i have data ,

and attached qvw has my situation ,

Calculated account C , is not distributing as per my cyclic group.

please help

agni_gold — Sat, 22 Aug 2015 18:41:15 GMT

Please see my below response and help

agni_gold — Sat, 22 Aug 2015 18:41:25 GMT

Please see my below response and help