How to show last seven days data in chart

[siva_boggarapu]

Hi Everyone,

I have chart which is having 3 months data.But, I want to show chart  since last one week data. Can anyone help on this?

Best,

Siva.

[nilesh_gangurde]

Hi siva,

You can use write the expression using ( today() - (today() - 7) ) 

if possible attach the sample data.

Regards,

Nilesh Gangurde

[siva_boggarapu]

Hi Nilesh,

can you please see the table below. I want show  last one week data.

name	code	date
AAA	123	5/3/2012
AAA	123	5/2/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	5/1/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/27/2012
AAA	123	4/26/2012
AAA	123	4/26/2012
AAA	123	4/26/2012
AAA	123	4/26/2012
AAA	123	4/26/2012
AAA	123	4/26/2012

best,

siva.

[#4]

Hi Siva,

you must add in your table where the date is stored a new information which will flag the date as being in the last seven days (1) or not (0).

Then in the graph you use a set analysis to consider it; means it will display only records with flag=1.

If you do not know how to use set analysis, let me know

best regards

christian

[siva_boggarapu]

Hi Christianj,

I don't have much idea on set analysis. can you please tell me how to do it?

Best,

Siva

[sridhar240784]

Hi,if I understood your question properly

Below is the expression.

=sum({<datefield={'$(date(today()-7))'}>} value field)

Make sure your date format is correct

-Sridhar

[#7]

Hi Siva,

you must put this as an expression or calculated dimension.

=only({$<Flag={'1')}>}>} Date)

best regards

chrsitian

Selon "siva.boggarapu" <qliktech@sgaur.hosted.jivesoftware.com>:

siva.boggarapu created

the discussion

"Re: How to show last seven days data in chart"

To view the discussion, visit:

http://community.qlik.com/message/216295#216295