Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This could help you: Re: Document Analyzer V1.15
Hi,
Find the latest copy of the same attached.
Regards
ASHFAQ
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,