Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
saiyashwan
Contributor
Contributor

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

servicecountpricetotal price
service143.514
service281296
service35525
service61614224
service812672
service1034351190

 

excepted table display 

servicecountpricetotal price
service143.514
service281296
service35525
service4030
service5050
service61614224
service7070
service812672
service9080
service1034351190
0 Replies