Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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
Champion III
Champion III

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,