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: 
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 - Specialist
Partner - Specialist

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 - Specialist
Partner - Specialist

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 - Specialist
Partner - Specialist

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;

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.