Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
GaonyadiweK
Contributor
Contributor

Some records missing

Community please assist. We have some records missing in the report. For example, in the leave report. There is a record missing until someone from the transaction system alert us. So it doesn't show until we search for it using the search box. After searching for it, they it shows and all other records that were not showing before. So it means the information is there but not showing until we search for it. Please assist

 

3 Replies
SharathPanackal
Partner - Contributor III
Partner - Contributor III

Please provide more details. 

When you say the information is not seen, where exactly is it supposed to be seen.

Is it part of a chart with set analysis? Are you searching for a particular field in the search box. Once you select the value through search box does the record come up in a chart all of a sudden. Please provide more clarity in the issue 

Regards,

Sharath Panackal

GaonyadiweK
Contributor
Contributor
Author

Like in the dashboard it shows that the employee took leave for 3 days. In the detail straight table it shows the dates for those days. Until HR tells us that it is actually 4 days and give the date. When we go to the date and search that date then all of a sudden we have 4 days in the dashboard, and also on the detail it shows 4 records. Only after searching. 

avkeep01
Partner - Specialist
Partner - Specialist

Hi @GaonyadiweK

In Sense you could check the "include zero values" at the dimensions and "include zero values" at the add ons menu. 

in QlikView you could uncheck the "hide zero values" or check "show missing values". 

Besides that I don't have to much information to go with. Could you add some print screens etc. to explain your question a bit more.