Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;
Hi,
which version of QlikView Desktop?
S.
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
I am using Qlikview 11.20 SR 9 version
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.
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
But I loaded only one column and rest of columns not required. In that time also is it required.
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