Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:Script error

hi all,

I hve master calender when i am usng innerjoin it shwng error......

y it is shwng error in temp calender?

18 Replies
Chanty4u
MVP
MVP
Author

example:

date   ---  14-05-15

tamilarasu
Champion
Champion

Change the MinMax table script like below,

MinMax:

Load

Max(Date#(Date,'DD-MM-YY')) as MaxDate,

Min(Date#(Date,'DD-MM-YY'))  as MinDate

Resident TASKDETAILS;

jagan
Luminary Alumni
Luminary Alumni

Hi Suresh,

The variables vMaxDate & vMinDate values are empty.  Verify below code carefully


MinMax:

Load

Max(Date) as MaxDate,

Min(Date) as MinDate

Resident TASKDETAILS;

// Creating Date Variables

Let vMinDate=Num(Peek('MinDate',0,'MinMax'));

Let vMaxDate=Num(Peek('MaxDate',0,'MinMax'));

Let vToday = $(vMaxDate);

Drop Table MinMax;

// TEMPORARY CALANDER

TempCal:

Load

     Date($(vMinDate)+ RowNo() -1) as TempDate

     AutoGenerate $(vMaxDate) - $(vMinDate) +1;

Chanty4u
MVP
MVP
Author

but values are there....what might be the reason?

Chanty4u
MVP
MVP
Author

yeah...its wrkng now... but... ihve five dates its shwng in diffrnt rows...

but i want in same row?

PFA'

in task code i hve 5......in dates its shwng in diff rows

Chanty4u
MVP
MVP
Author

error got resolved but ...date values shwng in diff rows

jagan
Luminary Alumni
Luminary Alumni

Hi,

All this fields are in Same table?  Then do Group by in script, or use Max() for all the date fields.

Regards,

jagan.

Chanty4u
MVP
MVP
Author

yeah... all in same table..how can i do?

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Data:

SELECT

Field1,

Field2,

Sum(Field3) AS Field3,

Sum(Field4) AS Field4

FROM TableName

Group By Field1, Field2;