topic Re: Tips on Debugging..? in QlikView

Tips on Debugging..?

Tue, 30 Oct 2012 09:58:36 GMT

Just started QlikView on the 1st of Oct, getting really used to the interface ect, getting on with knowing the functions ect..

So i just need a few guidance tips on how to debug properly.

I know this is a very broad question but any guidence would help.

Hopefully a collection of individuals methology would create a nice how to debug thread.

Thankyou in advance

Rhys Bradbury

Re: Tips on Debugging..?

gandalfgray — Tue, 30 Oct 2012 10:18:52 GMT

Hi Rhys

1. Turn on logging (Settings->Document Properties->General. Check "Generate Logfile")

2. Run in debug mode stepping through your application or using breakpoints

3. If you are getting duplicates you were not expecting, they may be caused by joins. Use NoOfRows function before and after the join to check if the join introduces duplicates. (Let nBefore=NoOfRows('tablename'); etc..)

4. You can also "dump" tables at any point you like by using the Store command, and then inspect what is in the table at that stage

that's a start at least..

Re: Tips on Debugging..?

whiteline — Tue, 30 Oct 2012 14:23:23 GMT

Hi.

In addition Document properties->Tables can be useful.

Re: Tips on Debugging..?

Wed, 31 Oct 2012 10:02:27 GMT

Everyone who contributes gets a like ^_^