Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight Table with Just Today's Date

Hi,

I'm trying to create a Straight Table with just today's date. My problem is that the dates I'm using are in a strange format:

Actual Start/End Date: 1YYMMDD

1150602 = 02/06/2015

In this example, I want to end up with a table that has just Run1's and Run2's (as they match in both tables) and only the results that will match today's date - in this case 4 results match 02/06/2015.

Scheduled Runs

NameDescription
Run1ABC
Run2123
Run3XYZ
Run4456

Actual Runs

NameStatusActual Start DateActual End Date
Run1C11505291150529
Run1C11506031150602
Run1F11506031150602
Run2F11506011150602
Run2C11506031150602
Run2C11506031150602
Run6C11506031150602
Run7C11506031150602

Any help is greatly appreciated.

Kind regards,

Tristan

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like attached?

View solution in original post

3 Replies
swuehl
MVP
MVP

Maybe like attached?

maxgro
MVP
MVP

actrun:

LOAD Name,

     Status,

     date(date#(right([Actual Start Date],6),'YYMMDD')) as [Actual Start Date],

     date(date#(right([Actual End Date],6),'YYMMDD')) as [Actual End Date]

FROM

[https://community.qlik.com/thread/166596]

(html, codepage is 1252, embedded labels, table is @2)

Where

date(date#(right([Actual Start Date],6),'YYMMDD')) = Today(1)

and [Actual Start Date] = [Actual End Date]

;

schrun:

inner Keep (actrun)

LOAD Name,

     Description

FROM

[https://community.qlik.com/thread/166596]

(html, codepage is 1252, embedded labels, table is @1);

Not applicable
Author

Thanks very much Swuehl, that's nailed it!

Kind regards,

Tristan