topic Re: Check whether an extracted field has been used or not in QlikView

Check whether an extracted field has been used or not

Thu, 17 Jul 2014 11:24:59 GMT

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

Re: Check whether an extracted field has been used or not

tresB — Thu, 17 Jul 2014 11:27:52 GMT

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

Re: Check whether an extracted field has been used or not

ashfaq_haseeb — Thu, 17 Jul 2014 11:37:19 GMT

Hi,

Find the latest copy of the same attached.

Regards

ASHFAQ

Re: Check whether an extracted field has been used or not

puttemans — Thu, 17 Jul 2014 11:37:21 GMT

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,