topic Re: Table Data required in App Development

Table Data required

swiftfahad — Fri, 15 Nov 2024 21:36:46 GMT

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.

sidhiq91 — Fri, 07 Jul 2023 11:43:25 GMT

@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 — Thu, 13 Jul 2023 08:31:33 GMT

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