Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Category | Sub Category | Year | Actual_Sales | Target_Sales |
A | A1 | 2018 | 10 | 20 |
A | A2 | 2018 | 2 | 5 |
A | A3 | 2019 | 42 | 20 |
A | A4 | 2019 | 11 | 10 |
B | B1 | 2018 | 10 | 25 |
B | B2 | 2018 | 2 | 10 |
B | B3 | 2019 | 30 | 30 |
C | C1 | 2018 | 11 | 22 |
C | C2 | 2018 | 23 | 30 |
C | C3 | 2018 | 40 | 50 |
C | C4 | 2019 | 20 | 15 |
C | C5 | 2019 | 11 | 20 |
please give any suggestions
thanks in advance
The gap should be =sum(Actal_Sales)
The expression should be sum(Target_Sales)-sum(Actual_Sales)
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
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
The gap should be =sum(Actal_Sales)
The expression should be sum(Target_Sales)-sum(Actual_Sales)
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