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

saiyashwan — Sat, 16 Nov 2024 03:11:56 GMT

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

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

dplr-rn — Mon, 24 Jun 2019 20:05:51 GMT

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;

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

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

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