topic Re: Searching variables in QW Project in QlikView

Searching variables in QW Project

Anonymous — Mon, 04 Aug 2014 14:08:00 GMT

Hi,

i have a QW project with its script, its tables, its graphs and.........

Now, i want to delete a variable from the script because it's useless.

How can i do to check if i use that variable in my project ?

From the menu "Setting" -> "Expression" i can serch into the expressions if my variable has been use but i have no idea if there are better way to do that and how to search if my variable has been use has dimension or anything else.

Regards,

Luca

Re: Searching variables in QW Project

fernando_tonial — Mon, 04 Aug 2014 14:13:09 GMT

Hi, download this file.

robwunderlich.com/downloads/DocumentAnalyzer_V2.1.qvw

by Rob Wunderlich

Best Regards.

Tonial.

Re: Searching variables in QW Project

Anonymous — Mon, 04 Aug 2014 14:55:16 GMT

i downloaded it but in my opinion there's an error.

as you can see in the image: the analyzer show that field "dat.COST_O&M" is not used but i reported my project where that field is used....

Am i wrong ?

Re: Searching variables in QW Project

Mon, 04 Aug 2014 17:10:14 GMT

Hi Luca, Generally we can delete or de-allocate the variables in the script like below:

SET vFlag = 1 ;

Load statements Here

SET vFlag = ; OR SET vFlag = Null() ;

Re: Searching variables in QW Project

rwunderlich — Wed, 06 Aug 2014 15:13:21 GMT

Hi Luca,

That may be a bug in DocAnalyzer. I'll test and I may contact you for more information.

-Rob

Re: Searching variables in QW Project

rwunderlich — Thu, 07 Aug 2014 04:08:50 GMT

Hi Luca,

That does appear to be a possible bug. Can you contact me via the contact form at

http://qlikviewcookbook.com/contact/

so I can work with you on it?

Thanks,

Rob