problem when debug in script

[Anonymous]

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

[MK_QSL]

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

[Anonymous]

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;

[simospa]

Hi,

which version of QlikView Desktop?

S.

[Anonymous]

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

[Anonymous]

I am using Qlikview 11.20 SR 9 version

[Anonymous]

Hi

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

[Anonymous]

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

[Anonymous]

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

[Mark_Little]

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