topic Total column in bar chart in QlikView

Total column in bar chart

Jason_Michaelides — Wed, 17 Nov 2010 14:05:35 GMT

Hi All,

I have a similar challenge (I think) to this one (http://community.qlik.com/forums/p/17002/145124.aspx#145124) and have tried to convert the answer for my needs but have failed so far!

I have a table (Data) with many transactions, each with a Tx_Type (e.g. BUDGET, COMMITTED, REQ, PAID) and Amount. I'm trying to get to a bar chart that has the Tx_Type as the dimension with SUM(Amount) as the value. OK, this bit is obviously easy, but I also then need a final column that is Forecast. This is a sum of all Tx Types, except BUDGET.

Can anyone help!

Thanks in advance,

Jason

Total column in bar chart

john_duffy — Wed, 17 Nov 2010 14:42:05 GMT

Hi Jason.

I have attached a sample application in which I create the total Forcast amount in the load scripts. Basically I sum all of the values (except for Budget) in a separate table and then attach this to the original Transaction table.

Let me know if this helps.

John.

Total column in bar chart

Jason_Michaelides — Wed, 17 Nov 2010 16:03:04 GMT

Thanks John - that really helps. It certainly gives me a solution, although I have to make sure I exclude the new Tx_Type in all other objects, which is a pain.

Would be great if there was a way to have dynamic dimension values...

Jason

Total column in bar chart

johnw — Thu, 18 Nov 2010 01:00:22 GMT

Applying the suggestion I made in that thread to create a new field, see attached.

Total column in bar chart

Jason_Michaelides — Thu, 18 Nov 2010 12:03:40 GMT

John (W) - so simple but exactly what I needed!

Thank you so much mate.

Jason

Total column in bar chart

Mon, 22 Nov 2010 13:20:41 GMT

really good

its helped me lot