topic Re: How to find missing data in Qlikview in QlikView

How to find missing data in Qlikview

gunji767 — Mon, 18 Jul 2016 07:16:22 GMT

how to find missing data,after loading data from excel in to qlikview? in excel it shows me the correct after importing dat into the qlikview,some data is missing.

Re: How to find missing data in Qlikview

karthikoffi27se — Mon, 18 Jul 2016 08:05:31 GMT

Hi Hareesh

Can you please share your sample data?

Many Thanks

Karthik

Re: How to find missing data in Qlikview

kaushiknsolanki — Mon, 18 Jul 2016 08:15:43 GMT

Hi,

You can check the numbers of records which are loaded in Qlik and cross check that with Excel record.

Go to Settings -> Document Setting -> Tables.

You can also check the distinct data of the field from this tab.

Regards,
Kaushik Solanki

Re: How to find missing data in Qlikview

MindaugasBacius — Mon, 18 Jul 2016 08:33:14 GMT

Could you share data example (excel) of which you're missing?

Re: How to find missing data in Qlikview

marcus_sommer — Mon, 18 Jul 2016 08:41:09 GMT

I think it's quite similar to: About duplicate values

- Marcus

Re: How to find missing data in Qlikview

ThornOfCrowns — Mon, 18 Jul 2016 08:41:19 GMT

This seems like another in the 'Distinct values' questions. Have a look at the other threads opened very recently which all seem to have the same issue(s)

Re: How to find missing data in Qlikview

ankurakash — Mon, 18 Jul 2016 08:54:19 GMT

During your data load into Qlikview app there is a rocess of 'Enable transformation step'. Do click on it and view what data it displays. The data it displays will be the final data into your application. It will help you to take action on what data is missing and why the data is not pulled which otherwise is not applicable in general situation.

In case if you are pulling multiple excel sheets check out for their field formats and also the xls and xlsx file.

Hope it helps.

If the above does not help do share a dummy excel file with similar kind of content in this thread.

Regards,

Akash

Re: How to find missing data in Qlikview

Mark_Little — Mon, 18 Jul 2016 09:01:09 GMT

I would make sure you have a distinct or unique field in the file. If not add a field on loading like...

RowNo() as Key.

Then us the field to make sure they all come through.

Mark