Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabum
Creator
Creator

how to find missing table information ?

Hi Experts

I am Having Excel file with 3 tables (Sheet 1, Sheet 2, Sheet 3)

Note : Having Values for Sheet 1 & Sheet 3

I am already loaded sheet 1 & Sheet 3 data


But , I want to show the Missing table Information . How ?

6 Replies
marcus_sommer

It's already included - what is unclear?

how to skip a Excel Workbook ?

- Marcus

madhubabum
Creator
Creator
Author

Hi Marcus

Thanks for your reply,

I want Missing Table Information Only ?(Which sheet is Missing )

Output : Sheet 2 (like that)

marcus_sommer

You mean the file-informations then the sheet is in all files the same and this will be append to the origin data-table per concatenate-statement within the else-part from loop and could create a tablebox like this:

- Marcus

ganeshreddy
Creator III
Creator III

Hi Marcus,

I am also looking for same result can you please add a QVW for the screen shoot which you have given for missing data and data. It would be very helpful to me.

Best Regards,

Ganesh

marcus_sommer

This is attached in my last answer to how to skip a Excel Workbook ?

- Marcus

ganeshreddy
Creator III
Creator III

Thank you.