topic Graph Expression Query in QlikView

Graph Expression Query

anthony_kinsell — Wed, 20 May 2015 11:37:46 GMT

Hi,

I'm trying to show the accumulation of a cost split between 2 accounts that it will be taken from. Attached is my output.

My formula is simple Sum([Cost Draw Down]) & I have ticked the 'Full Accumulation' box on the expression tab

What I need it to do is to continue showing the €2,000,000 for the Equity account in the periods 30/04/15 - 31/10/15.

Anybody any ideas?

anthony_kinsell — Wed, 20 May 2015 11:46:54 GMT

Sorry I meant to say that I think I need to do some type of aggregation?

vishsaggi — Wed, 20 May 2015 12:31:41 GMT

Hi Anthony,

Is it possible to share a sample .qvw file you have been trying.

Tks,

anthony_kinsell — Wed, 20 May 2015 13:02:56 GMT

No not really - too much sensitive info.

Basically I have a [Cost Draw Down] for the WC a/c & a [Cost Draw Down] for the Equity a/c.

The formula Sum([Cost Draw Down]) is giving me the correct totals for each a/c but I need the total [Cost Draw Down] split by account.

anthony_kinsell — Wed, 20 May 2015 13:22:35 GMT

Thanks for looking & any attempts at helping.

I worked out the answer.

Just needed to put in separate formula for each source:

Sum(If([Loan Name] = 'Equity Account', [Cost Draw Down]))

& remove the loan name as a dimension.