Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Check whether an extracted field has been used or not

Hey guys,

after I extracted, transformed, loaded table fields from data source into qlikview, is there a way to check whether the fields I have loaded are used in my dashboard design or not?

Many thanks and best regards,

Myr

3 Replies
tresesco
MVP
MVP

This could help you: Re: Document Analyzer V1.15

ashfaq_haseeb

Hi,

Find the latest copy of the same attached.

Regards

ASHFAQ

puttemans
Specialist
Specialist

Hi,

Apart from the fact that the figures seem to be fine, there are plenty of ways to do some checks.

One is to keep track of the number of lines 'loaded' in each step when you launch the script. If they remain stable, you may assume all the data are there, and none are lost

Another one is to load a list box or a table box on the sheet with the parameters you want to check. If the variables/values you expect are there then it should be fine.

A third one could be to add a text object on your sheet, and then define what you want to see (e.g. count('variable x')) This example will tell you how many lines of variable x are recognized and used.You could do this for several parameters.

A fourth one is to export your complete table (or part of it) from your dashboard to excell, and make some checks there.

Regards,