Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

NOTES FROM LAST WEEK

Heeello,

Does anyone know how to "script" : take the last [Commnent] from Today -7

I have two columns: Anotation_Date and Comment and i only want to have a chart with the all comments of the last week.

Many thanks!!

B.

1 Solution

Accepted Solutions
jpapador
Partner
Partner

This is an example if the data is coming from a spreadsheet but always do the where clause at the bottom.

Comments:

LOAD

     Comment,

     Date

FROM

(ooxml, embedded labels, table is Sheet1)

Where Date >= Today()-14

and Date <= Today()-7;

View solution in original post

6 Replies
juleshartley
Specialist
Specialist

I would either use the load to add a field called something like 'Comments_last_week' that only populated comments for the previous week, or use set analysis in a chart object to filter the results based on annotation_date

jpapador
Partner
Partner

You want to do a where clause like below when you load in the comments table.

CommentsTable:

LOAD

Comments as LastWeekComments,

Anotation_Date

FROM "YOUR TABLE HERE"

Where Anotation_Date>= Today()-14

and Anotation_Date<= Today()-7;

Not applicable
Author

Many thanks both, I think the second option suits me...but I dont know how to script "where" can you type exactly?

Thanx!

B

Not applicable
Author

Many thanks both, I think the second option suits me...but I dont know how to script "where" can you type exactly?

Thanx!

B

jpapador
Partner
Partner

This is an example if the data is coming from a spreadsheet but always do the where clause at the bottom.

Comments:

LOAD

     Comment,

     Date

FROM

(ooxml, embedded labels, table is Sheet1)

Where Date >= Today()-14

and Date <= Today()-7;

View solution in original post

Not applicable
Author

It worked!

Many thanks

Maybe you can help me with this... the average should be 100% for the 12 sites but because there are more than one anotation for a single site (because of the different annotation dates) does it make senes to you?

Many thanks in advance,

BQ.