Table Data required

[swiftfahad]

Location	Type	Scale	Total_Vaccancy
EAST	Authorize	Scale-1	2
EAST	Occupied	Scale-1	1
EAST	Authorize	Scale-2	3
EAST	Occupied	Scale-2	1
EAST	Authorize	Scale-3	5
EAST	Occupied	Scale-3	4
WEST	Authorize	Scale-1	1
WEST	Occupied	Scale-1	1
WEST	Authorize	Scale-2	0
WEST	Occupied	Scale-2	0
WEST	Authorize	Scale-3	3
WEST	Occupied	Scale-3	2
NORTH	Authorize	Scale-1	1
NORTH	Occupied	Scale-1	1
NORTH	Authorize	Scale-2	4
NORTH	Occupied	Scale-2	2
NORTH	Authorize	Scale-3	3
NORTH	Occupied	Scale-3	2
SOUTH	Authorize	Scale-1	7
SOUTH	Occupied	Scale-1	4
SOUTH	Authorize	Scale-2	5
SOUTH	Occupied	Scale-2	3
SOUTH	Authorize	Scale-3	2
SOUTH	Occupied	Scale-3	2

I have above oracle data base table with the name of Vaccancy status loading with simple sql query .

Now i want to show follwing graph on qlik view plz guide if any one can build this for me.

		Occupied
Location	Authorize	Scale-1	Scale-2	Scale-3	Total_Occupied	GAP
EAST	10	1	1	4	6	4
WEST	4	1	0	2	3	1
NORTH	8	1	2	2	5	3
SOUTH	14	4	3	2	9	4

[sidhiq91 · Accepted solution]

@swiftfahad  Please use the expression below for each metric:

Authorize: sum({<Type={'Authorize'}>} Total_Vaccancy)

Scale-1 Occupied : sum({<Scale={'Scale-1'},Type={'Occupied'} >} Total_Vaccancy)

Scale-2 Occupied : sum({<Scale={'Scale-2'},Type={'Occupied'} >} Total_Vaccancy)

Scale-3 Occupied: sum({<Scale={'Scale-3'},Type={'Occupied'} >} Total_Vaccancy)

Total Occupied: sum({<Type={'Occupied'} >} Total_Vaccancy)

GAP: Column(1)-Column(5)

IF this resolves your issue, please like and accept it as a solution.

[swiftfahad]

Accepted as solution but this solution needs to hardcord the scale values in expresstion.  thank alot