topic Re: problem when debug in script in QlikView

problem when debug in script

Anonymous — Wed, 27 Jan 2016 13:33:49 GMT

Hi all,

I am debugging my script and not able to continue for further step. It got struck when I am doing max(date). Though it is silly, but I couldn't figure ot

I have written like below

Load max(date)

from facte_table.QVD

if I do without max it is working fine when limit records in debug mode. I mean

Load date from

fact_table.QVD.

Can any one tell me what might be the cause.

Thanks in advance.

Kumar

Re: problem when debug in script

MK_QSL — Wed, 27 Jan 2016 13:40:02 GMT

Could be there are many date and debug is taking time to find the Max(date)..

Also I hope this is only a typing mistake..

Load max(date)

from facte_table.QVD

fact_table.qvd not facte_table.QVD

Re: problem when debug in script

Anonymous — Wed, 27 Jan 2016 13:42:18 GMT

max() is a grouping function, you need to group by like?

Load

ID,
max(date) as Date

from facte_table.QVD

group by ID, date;

Re: problem when debug in script

simospa — Wed, 27 Jan 2016 13:43:30 GMT

Hi,

which version of QlikView Desktop?

Re: problem when debug in script

Anonymous — Wed, 27 Jan 2016 13:53:11 GMT

Hi,

Thanks for your quick reply. In my fact table I have more than 50 columns are there.

after group by id and date field also required.

Regards,

Kumar

Re: problem when debug in script

Anonymous — Wed, 27 Jan 2016 13:54:04 GMT

I am using Qlikview 11.20 SR 9 version

Re: problem when debug in script

Anonymous — Wed, 27 Jan 2016 13:55:36 GMT

actually I am doing by going to particular path and opening that particular QVD. It might be typo error when I am writing here.

Re: problem when debug in script

Anonymous — Wed, 27 Jan 2016 13:56:31 GMT

If you are using 50 fields in that table then you have to write all the fields in group by statement like...

group by field1, field2, field3, field4 ...so on

Re: problem when debug in script

Anonymous — Wed, 27 Jan 2016 14:01:11 GMT

But I loaded only one column and rest of columns not required. In that time also is it required.

Re: problem when debug in script

Mark_Little — Wed, 27 Jan 2016 14:01:58 GMT

Hi,

Depends what you are trying to do with the max date?

If you just want the max date you could

Load

MAX(Date) as MaxDate

Resident FactTable;

If you want a max date per some other field then you the have to start looking at group by.

Mark

Re: problem when debug in script

Anonymous — Wed, 27 Jan 2016 14:05:38 GMT

Resident table is required when we we do max(date) field. I need only one column, not more than that date column.

Re: problem when debug in script

swuehl — Wed, 27 Jan 2016 14:20:13 GMT

Load max(date)

from facte_table.QVD

If field and file name is correct, this should work, if date is a field showing numbers. Maybe it's just showing text values?

Then Max() won't work (on pure text values).

What error message do you get? Could you be more specific what the issue is you are encountering?

Re: problem when debug in script

Anonymous — Wed, 27 Jan 2016 14:52:21 GMT

actually it is timestamp and i have given name exactly as database.