topic Re: NOTES FROM LAST WEEK in QlikView

NOTES FROM LAST WEEK

Fri, 10 May 2013 15:01:54 GMT

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!!

Re: NOTES FROM LAST WEEK

juleshartley — Fri, 10 May 2013 15:54:41 GMT

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

Re: NOTES FROM LAST WEEK

jpapador — Fri, 10 May 2013 18:42:52 GMT

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;

Re: NOTES FROM LAST WEEK

Fri, 10 May 2013 18:44:06 GMT

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

Thanx!

Re: NOTES FROM LAST WEEK

Fri, 10 May 2013 18:45:05 GMT

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

Thanx!

Re: NOTES FROM LAST WEEK

jpapador — Fri, 10 May 2013 18:45:39 GMT

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;

Re: NOTES FROM LAST WEEK

Sat, 11 May 2013 09:09:12 GMT

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.