data not present in database but Qlik table should display the service with with zero value

[saiyashwan]

data not present in database but Qlik table should display the service with with zero value

I have the data in coming like this format , however, there are additional services but there is no data present in db(ex: service 4, 5, 7 &9) thus, data didn't get pulled and table is showing these services..but my requirements  is show in table all the services though there is data available or not.. can you help how to write expression to display this.

Due to data to available in db table displaying the values only where data is present in db

service	count	price	total price
service1	4	3.5	14
service2	8	12	96
service3	5	5	25
service6	16	14	224
service8	12	6	72
service10	34	35	1190

excepted table display 

service	count	price	total price
service1	4	3.5	14
service2	8	12	96
service3	5	5	25
service4	0	3	0
service5	0	5	0
service6	16	14	224
service7	0	7	0
service8	12	6	72
service9	0	8	0
service10	34	35	1190

Add tags

[saiyashwan]

I have the data in coming like this format , however, there are additional services but there is no data present in db(ex: service 4, 5, 7 &9) thus, data didn't get pulled and table is showing these services..but my requirements  is show in table all the services though there is data available or not.. can you help how to write expression to display this.

Due to data to available in db table displaying the values only where data is present in db

service	count	price	total price
service1	4	3.5	14
service2	8	12	96
service3	5	5	25
service6	16	14	224
service8	12	6	72
service10	34	35	1190

excepted table display 

service	count	price	total price
service1	4	3.5	14
service2	8	12	96
service3	5	5	25
service4	0	3	0
service5	0	5	0
service6	16	14	224
service7	0	7	0
service8	12	6	72
service9	0	8	0
service10	34	35	1190

[dplr-rn · Accepted solution]

you will need to add data to force 0s

use something like below

comm:
load * Inline [
service,	count,	price,	total price
service1,	4	,3.5,	14
service2,	8	,12,	96
service3,	5	,5,	25
service6,	16,	14,	224
service8,	12,	6,	72
service10,	34,	35,	1190
];

service:
load * inline [
servicetemp
service1
service2
service3
service4
service5
service6
service7
service8
service9
service10
];

load servicetemp as service
,0 as count
,0 as price
,0 as [total price]
resident service
where not Exists(service,servicetemp);
drop table service;