Source data for a Chart from another Straight Table

[#1]

Hi,

I have a straight table with calculated expressions and several dimensions. I now want to use the data from this table (only some dimensions & expressions) as input data for a bar chart and/or another table. Is this possible in QV 10 ?

Thanks.

[magavi_framsteg]

Hi again mayank.

I don't get it.

How do you derive this result from the input table - what is the logic?

Customer	Debit	Credit
Cust1	200	550
Cust2	0	100

Do you have to select the state first?

And currency? Group?

For me, it doesn't mean anything.

Ok Cust1 has 200d and 550c. In Total? Per group? Per currency or what?

I mean... when is it you want the table to result like that?

I get it that Cust1 has 200d for group G1 and currency EUR.

But the table doesn't show that to me. It looks like Cust1 has 200d in total.

Cust1 550c I could never derive....

[#3]

The final output table is really an aggregation of the AMT data at a Customer level using the Intermediate result. During aggregation, +ve values go to CR and -ve go to the DR buckets.

Intermediate result is a netting of the AMT by GroupNum, Currency.

I need to figure out the right sytax for the AGGR (or TOTAL) function that can get me the desired intermediate result.

[Jason_Michaelides]

Hi Mayank,

After a lot of fiddling I got this sorted for my own, similar challenge today. When I get home I'll look at your app and see of the same logic works. You don't need TOTAL, just Aggr()

Jason

[Jason_Michaelides · Accepted solution]

Here you go:

Credit:

Sum(Aggr(if(sum(Amt) >= 0,sum(Amt),0),GroupNum,Currency))

Debit:

Sum(Aggr(if(sum(Amt) < 0,sum(Amt),0),GroupNum,Currency))

Hope this helps,

Jason

[#6]

Worked as expected. Thanks.

[Jason_Michaelides]

Cool. Please mark the correct answer to close the thread.