topic Re: How to get data from chart within date range? in QlikView

How to get data from chart within date range?

Tue, 19 May 2015 12:44:50 GMT

Hi,

I have chart data in qvw. All I need is filter on dates. I need to run report every Tuesday.

for eg: if I run the report on 19/05/2015. the data in chart should show from three Tuesdays back. i,e it should show from 28/04/2015 to 11/05/2015. this should be happen every Tuesday.

so, if I run the report on next Tuesday the data should show from 05/05/2015 to 18/05/2015 and so on for every week.

The Date field have values from 2006 to 2015

would it be possible to do this using any variable? or in script?

Please can anyone suggest me how to do this.

Thanks.

Re: How to get data from chart within date range?

sunny_talwar — Tue, 19 May 2015 13:09:52 GMT

Hey Amelia, would you be able to share a sample?

Best,

Sunny

Re: How to get data from chart within date range?

robert_mika — Tue, 19 May 2015 13:16:58 GMT

If you run the report on Wednesday should it show from last Tuesday back or from Wednesday 3 weeks back?

Re: How to get data from chart within date range?

Tue, 19 May 2015 13:29:14 GMT

if I run on Wednesday it should show from three Wednesdays back To last Tuesday.

Re: How to get data from chart within date range?

Tue, 19 May 2015 13:29:50 GMT

see attached.

Re: How to get data from chart within date range?

Tue, 19 May 2015 14:03:00 GMT

is it possible to do this? let me know please.

Re: How to get data from chart within date range?

sunny_talwar — Tue, 19 May 2015 14:04:55 GMT

Do you want to remove any data that isn't in that range or do you want to make a selection in that particular range or do you have a specific chart you want to see for that range???

Best,

Sunny

Re: How to get data from chart within date range?

antoniotiman — Tue, 19 May 2015 14:06:21 GMT

Hi Amelia,

see attachment.

Regards,

Antonio

Re: How to get data from chart within date range?

Tue, 19 May 2015 14:15:18 GMT

I want to make a selection in that particular range.

Re: How to get data from chart within date range?

Tue, 19 May 2015 14:55:29 GMT

Thanks. I have used this. it is not showing data within date range instead showing all values. do I need to change anything?

Re: How to get data from chart within date range?

antoniotiman — Tue, 19 May 2015 15:04:53 GMT

what do You want to see ? where ?

Re: How to get data from chart within date range?

Tue, 19 May 2015 15:13:06 GMT

I want to seethe data with in date range. I have used the expression. but it is not showing data based on expression.

Re: How to get data from chart within date range?

sunny_talwar — Tue, 19 May 2015 15:18:11 GMT

See if this helps (PFA)

Best,

Sunny

Re: How to get data from chart within date range?

antoniotiman — Tue, 19 May 2015 15:28:53 GMT

Add Your expression

Re: How to get data from chart within date range?

Tue, 19 May 2015 15:49:21 GMT

Thanks. The date range which you used is correct. is there any way to include

Date(vToday - 21) & '<=' & Date(vToday - 😎

into chart expression?. so, that it will populate data automatically with out any selection.

let me know please.

Re: How to get data from chart within date range?

Tue, 19 May 2015 15:51:15 GMT

Count({<Date={">$(=Date(Max(TOTAL Date)-21))<=$(=Date(Max(Date)))"}>} [Yes or No])

Re: How to get data from chart within date range?

sunny_talwar — Tue, 19 May 2015 16:20:28 GMT

This within your set analysis should restrict the results for those two weeks:

{<Date={"$(='>=' & Date(vToday - 21) & '<=' & Date(vToday - 8))"}>}

Re: How to get data from chart within date range?

antoniotiman — Tue, 19 May 2015 16:27:56 GMT

Change Count with MaxString