topic Re: Charts in QlikView

Charts

Tue, 12 Jun 2012 08:40:22 GMT

i want three expressions say Sum(Sales),Sum(Sales1) and Sum(Sales1) - Sum(Sales) and 1 dimension say salesperson .

i want to have Sum(Sales) and Sum(Sales1) should come as total for all the brand and Sum(Sales1) - sum(Sales) as per the brands in bar chart

I mean to say that sum(Sales) and Sum(Sales1) should not come for dimension but sum(Sales1) - sum(sales) should come for dimension in bar chart.

Please help

deepakk — Tue, 12 Jun 2012 09:07:32 GMT

hi Manish,

I hope the attach application helps you out.

Deepak

Tue, 12 Jun 2012 09:13:12 GMT

hi deepak

thanks for your reply .. but i want only one bar for sum(Sales) on the left and another bar on the right for sum(amt)

and in between sum(sales) - sum(amt) for all the dimensions

deepakk — Tue, 12 Jun 2012 09:26:43 GMT

hi Manish,

I am not sure if you can do that in the same chart. But you have a work around by creating two charts.

I have attach a sample.

Deepak