topic Re: How to Find gap between two different sales in bar chart in QlikView

How to Find gap between two different sales in bar chart

Gopi_E — Sat, 16 Nov 2024 02:28:56 GMT

Hi Qlikers,

@sunny_talwar can you look on to this

I want to show the gap between actual sales and target_sales in the form of bellow picture type

Data is like bellow

please give any suggestions

thanks in advance

miskinmaz — Mon, 16 Sep 2019 06:08:11 GMT

set a bar offset on your third expression of Gap analysis

Gopi_E — Mon, 16 Sep 2019 06:14:33 GMT

Hi Miskimez,

Thanks for the reply

I set an expression Actal_Sales-Target_sales in bar offset but it will give bellow pic

please give any suggestions

Vegar — Mon, 16 Sep 2019 06:32:47 GMT

The gap should be =sum(Actal_Sales)

The expression should be sum(Target_Sales)-sum(Actual_Sales)

Gopi_E — Mon, 16 Sep 2019 06:46:26 GMT

Thanks for spending valuable time

I find out the solution

In Bar-Offset I set expression for giving starting position like sum(Actual_Sales) so it will give exactly what I am expecting