topic Re: Some questions in QlikView

Some questions

bwisealiahmad — Tue, 22 Dec 2015 18:11:28 GMT

Got some questions:

Is there any way to script in the script editor so this shows where to put a breaking point in the debugger? Or a more favorable way of of commenting so that this helps out when debugging and where to put breaking points?
Can you nest Date# functions? Like Date(Date#(Date# 'DD-MM-YYYY'), D/MM/YYYY)) if you have different formats? Or do you use ALT for this?

Two questions that can't seem to to find an answer for.

Thanks for all help!

Re: Some questions

rwunderlich — Tue, 22 Dec 2015 20:09:04 GMT

I've never found breakpoints to be useful because there isn't much you can see in the debugger.

// and /* comments don't show up in the Document log. REM comments do. So if you want your comments to show up in the log to aid debugging, use REM.

Another debugging trick is to use the TRACE statement to write data to the log.

I also use a couple of Qlikview Component routines in my debugging.

Qvc.InspectTable -- pauses the script and lets you browse a table.

Qvc.TableStats -- logs row and field counts. Useful for seeing row counts before and after JOIN.

When testing for different potential date formats, I use Alt()..

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Some questions

bwisealiahmad — Tue, 22 Dec 2015 20:13:08 GMT

Thanks for responding regarding the scripting / breakpoint.

Reason I am asking is I remember these from the latest qv certification and got quite confused. Regarding the

Date(Date#(Date# related question I am wonder if it is possible or not? Or to do Date#(Date(Date(

Never seen it in practice, but really confused me.

Re: Some questions

rwunderlich — Wed, 23 Dec 2015 00:32:16 GMT

I don't know about the nested Date#(). Give it a try and let us know what you find out. As I said, I've always used Alt() which works for my needs. Guessing at dates is always a challenge.

1/12/2015

Is that MM/DD/YYYY or DD/MM/YYYY?

-Rob

Re: Some questions

Thu, 21 Apr 2016 09:45:23 GMT

Hi Ali,

Where you able to get the correct answer of the first question?

Also, Can you let me know more about the exam, I am thinking of taking it soon

Re: Some questions

d44973694 — Wed, 17 May 2017 11:56:44 GMT

I don't think that the REM statement appears in the log file. Only Trace does. REM can just have working breakpoint on it.

I included these 2 statements in my script

and here is the snapshot from log where only Trace statement can be seen, not the REM.

Re: Some questions

rwunderlich — Thu, 18 May 2017 18:26:53 GMT

I think that's a bug. The text appears in QV11.20, but not in QV12.10. Also, apparently from your screenshot it is asterisks in QS as well.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com