Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do that?

Dear all, I have 2 tables first one with data / hour and code and second one with code hour and days and I want to do the next

Table 1:

Date Code

18/03/2010 18:45 25

Second Table

Monday Tuesday Wednesday Thursday Friday Saturday Sunday Hour Days Code

0 0 1 1 1 0 0 15:00 3 25

I want to do the next one:

Get day name of the date

See for code

See on table 2 if day=1

if day=1 then check if hour >= Hour Date

If Hour>Hour(Date) - Then get Days

and calculate New date as date + Days (if days are saturday or sunday sum 1 for each one)

else

go to the next day and chek if = 1 if not eq 1 continue with next day (loop) and Then get days

and calculate New date as date + Days (if days are saturday or sunday sum 1 for each one)

if day = 0 goto next day (cyclic) till day = 1

And then calculate new date.

Can someone help me?

1 Reply
Not applicable
Author

Hi Jordi,

I would like to help you. Pls let me know the criteria / conditions in detail and what should be your output.

Regards

Rajesh