topic Last Whole Week On Chart in QlikView

Last Whole Week On Chart

Tue, 23 Feb 2010 07:57:55 GMT

Dear All,

I have two chart in my attached file. One of the chart shows some values for each week. And the other should show the latest whole week but there is something wrong in the file. For example today is 23rd of February I would like to present only last whole week (15-22 February interval) for the second chart. I want to see whole last week independently from the date selection. Would you please help me about it?

Hope to hear you soon.

Best Regards,

Last Whole Week On Chart

Tue, 23 Feb 2010 08:38:01 GMT

Hi there,

took a look at your file but struggled with the Turkish (?) language... see if the below helps.

Last Whole Week On Chart

Tue, 23 Feb 2010 08:47:15 GMT

Hi Lukas,

Thanks for your reply. But the result is not correct. You can cross check the result from the main chart. The values must be 180 , 142 ,142 for the last whole week. I made the correction by using below formula.Please check attached file. But I would like to learn using Set Analysis instead of above formula.

IF(Range='Last Week',Weekname(TARIHCQ))

Last Whole Week On Chart

Tue, 23 Feb 2010 09:00:55 GMT

Hi,

gotcha - you had for the dimension week-1.

I've removed the -1 and it works. Basically it IS using set analysis:


=sum({1}
if(inweek(TARIHCQ,WeekStart(Today(2)),-1),YI_SAYI)
)

The {1} means it's applying the expression on the whole data set, regardless of the current selection. Give it a try - select any date and the chart will still show the latest week's data only.

Last Whole Week On Chart

Tue, 23 Feb 2010 09:14:53 GMT

Hi Asim,

see the attached example for an SET ANALYSIS example.

Without selection: Graph shows the week before the actual week.

With selection: Week before selected week.

You can play around with it to become familiar with set Analysis.

Good luck!

Rainer

Last Whole Week On Chart

Tue, 23 Feb 2010 10:57:22 GMT

Hi Rainer,

Thanks for your reply. But this is not the solution for me. I want to be static view after reloading. For example when I reload the document it is required to show the value for week before the actual week. It must not effected with the selection of date.

Best Regards,

Last Whole Week On Chart

Tue, 23 Feb 2010 13:04:07 GMT

Hi Asim,

here a second try.

Good luck!

Rainer

Last Whole Week On Chart

Wed, 23 Mar 2011 08:54:25 GMT

Hi Rainer,

seems that I'm facing the same problem that Asim had a while ago. Unfortunately I'm still using the QVPE and can't open your attached file. Would you mind posting the set analysis formula? I want to show all order that were generated in the previous week - but only the previous week.

I tried to use this one but I did not work out they way I wanted ;-))

Sum({< Status = {'Offener Auftrag'}, [Erstellungsdatum] = {'>=$(=Week(Today() -1, 'DD.MM.YYYY'))'} >} [Auftragsmenge in Tonnen])

Thanks for your help and best regards
Günter