topic Show only several last weeks in QlikView

Show only several last weeks

Anonymous — Wed, 28 Nov 2012 17:14:13 GMT

Hi everyone,

I have historical data. I created chart with cyclic group (Week and Month).

I want to create some conditions, which show all data by Month and only dynamically last 12 weeks.

Do you have any ideas?

Thanks,

Re: Show only several last weeks

Anonymous — Wed, 12 Dec 2012 17:09:31 GMT

how can I do sort of weeks?

I calculate week variable

WeekStart(date(oDate))& '-' &WeekEnd(date(oDate)) as WEEK

Thanks,

Re: Show only several last weeks

Anonymous — Wed, 12 Dec 2012 19:54:01 GMT

How can I select only last 12 weeks for example?

I found

[Sort] Numeric Value ->Descending

[Dimension Limits] -> Show only First -> my value

But it looks not naturally data decrease from left to right

Do you have other ideas?

Maybe max(week)-max(week)-12 or aggr

Thanks

Re: Show only several last weeks

Clever_Anjos — Wed, 12 Dec 2012 20:21:28 GMT

Into your expression, use a Set Analisys to filter only 12 weeks

example:

SUM({<oDate={">=$(today()-84)"}>}Value)

Re: Show only several last weeks

Anonymous — Wed, 12 Dec 2012 20:55:34 GMT

it doesn't work.

Re: Show only several last weeks

Clever_Anjos — Wed, 12 Dec 2012 21:00:04 GMT

Could you post a qvw?

Re: Show only several last weeks

Anonymous — Wed, 12 Dec 2012 21:04:55 GMT

Try this syntax for set:

SUM({<oDate={"$(='>=' & date(today()-84))"}>} Value)

Regards,

Michael

Re: Show only several last weeks

Wed, 12 Dec 2012 21:31:40 GMT

Hi Vladmir,

Create a variable say Vweeks, and create a slider object from 1 to 12 ,Instead of the field name , select variables and in that list select the variable Vweeks. Go to the chart or the straight table which you want to show dynamically and in that Dimension limits ,select Show only LARGEST , = VWEEKS variable in values place

hope this helps

Regards,

Ramesh

Re: Show only several last weeks

Anonymous — Thu, 13 Dec 2012 16:30:19 GMT

Thank you for your help. it works.

I have some questions

1. if today is Friday, it starts from last 12th Friday. I need always start from Monday.

2. how can it expression in dimension?

Thanks again

Re: Show only several last weeks

Clever_Anjos — Thu, 13 Dec 2012 16:40:14 GMT

1) SUM({<oDate={"$(='>=' & weekstart(date(today()-84)))"}>} Value)

2) It´s better to have all weeks on a calendar at a script

Re: Show only several last weeks

Anonymous — Thu, 13 Dec 2012 18:12:25 GMT

Vladimir,

If you want Monday on or earlier than 12 weeks back, it is

weekstart((date(today()-84)))

If you want it on or later than 12 weeks back:

weekstart((date(today()-77)))

Reagrds,

Michael

Re: Show only several last weeks

Anonymous — Thu, 13 Dec 2012 18:14:45 GMT

Thank guys,

that's I understand. But I use cyclic group Time, where Months, Weeks and Days.

I want to cut time frame for each Variable.

Re: Show only several last weeks

Anonymous — Wed, 09 Jan 2013 20:02:42 GMT

Thanks Michael Solomovich.

I have a question. It works, when my oDate has 1 value for each day (like 9/1/2012: 9/2/2012 ...)

But when I have oDate many value for each day (10 for 9/1/2012, 5 for 9/2/2012 ...)

My original date variable looks

9/1/2012 4:20

9/1/2012 8:39

9/1/2012 10:13

9/1/2012 12:31

9/1/2012 13:00

9/1/2012 17:45

9/1/2012 19:07

9/1/2012 21:47

9/2/2012 11:38

9/2/2012 13:13

9/2/2012 13:16

9/2/2012 15:47

9/2/2012 17:55

9/3/2012 2:29

9/3/2012 11:35

9/3/2012 13:13

9/3/2012 14:02

9/3/2012 15:11

9/3/2012 20:29

9/3/2012 20:55

9/3/2012 21:08

9/3/2012 22:32

9/3/2012 23:22

when I load it, I use date(original date variable) as oDate. I have 10, 5 value for each day.

iN EXPRESSION I USE

count({<oDate={"$(='>=' & WeekStart(date(today()-28))"}>}[Value])

it doesn't work.

Could you suggest anything how solve it?

Thanks again,

Re: Show only several last weeks

Anonymous — Wed, 09 Jan 2013 20:07:32 GMT

Vladimir,

As a rule, we don't need hours and minutes. In this case I remove them on data load:

LOAD distinct

...

date(floor(oDate)) as oDate,

...

FORM ...

Regards,

Michael

Re: Show only several last weeks

Anonymous — Wed, 09 Jan 2013 20:23:50 GMT

Please see my attached file. I thought the problem in oDate variable, but no.

Could you check quickly what can be?

Thanks,

Re: Show only several last weeks

Anonymous — Tue, 15 Jan 2013 18:45:42 GMT

How select only last 4 weeks?

Please see my attached file. I hope you find issue.

I don't know how connect my expression and dimension. I think the problem in it.

Maybe I'm wrong.

Thanks,

Re: Show only several last weeks

Tue, 15 Jan 2013 21:08:43 GMT

Hi Vladimir,

First create a variable as mentioned before called vWeeks and set value to 1.

Next create a slider where you tell in settings that Data is use by variable(s) and then select vWeeks.

Set values from 0 to for example 12 with an increment of 1.

try following expression:

count({<oDate={">=$(=Date(WeekStart(date(today()))-($(vWeeks)*7)))"},[qID_3_Task completion]={'Yes'}>}[qID_3_Task completion])/

Count({<oDate={">=$(=Date(WeekStart(date(today()))-($(vWeeks)*7)))"}>}TOTAL<WEEK> [qID_3_Task completion])

See attached file for example.

Hope this will help.

Re: Show only several last weeks

Anonymous — Tue, 15 Jan 2013 21:11:24 GMT

You attached my file without changes

Re: Show only several last weeks

Tue, 15 Jan 2013 21:14:21 GMT

Vladimir,

sorry. Try the new attached file. On the right side of the screen you see a slider (and a table below).

I also changed you graph.

Selecting number of weeks in slider will change you graph.

Greetings,

Marc

Re: Show only several last weeks

Anonymous — Tue, 15 Jan 2013 21:24:04 GMT

Yeah, I see. Thanks.

<oDate={">=$(=Date(WeekStart(date(today()))-($(vWeeks)*7)))"}

I change ($(vWeeks)*7) for days without slider.

Thank youuuuuu!!!!!