topic Re: Week start selection in QlikView

Week start selection

its_anandrjs — Fri, 26 Aug 2011 07:36:00 GMT

Hi All,

I have urgent requirement that if i select the weekstart value in weekstart list box

it should display like when selection 8/8/2011

it should display this

8/7/2011

8/6/2011

8/5/2011

8/4/2011

8/3/2011

8/2/2011

8/1/2011

and sum the values on that days.

Regards

Anand

Week start selection

Fri, 26 Aug 2011 07:42:35 GMT

I may not undertsand the question - do you want to display each day as listed, or a sum for the listed date? Either way it should work as long as all your rows contain one field for the real date, and one field for the weekstart date.

What is shown then it depends on what fileds you choose to display...

Week start selection

sushil353 — Fri, 26 Aug 2011 07:47:04 GMT

Hi Anand,

Your problem is not understandable..please explain a bit more..

Week start selection

its_anandrjs — Fri, 26 Aug 2011 07:50:01 GMT

Hi,

Thanks for this on for this days

8/7/2011

8/6/2011

8/5/2011

8/4/2011

8/3/2011

8/2/2011

8/1/2011

How many customers are disconnect i need to find out but only on above days from 8/7/2011 to 8/1/2011 but selection is 8/8/2011 (Weekstart), If you need more information tell me and let me know.

Regards

Anand

Week start selection

its_anandrjs — Fri, 26 Aug 2011 07:56:57 GMT

Hi Kjer / All,

Scenario is this when i select the weekstart like 8/8/2011 so below dates are what

like this

8/7/2011

8/6/2011

8/5/2011

8/4/2011

8/3/2011

8/2/2011

8/1/2011

on this some customers are disconnect so i need to find out this like example:-

8/7/2011 22

8/6/2011 15

8/5/2011 10

8/4/2011 8

8/3/2011 5

8/2/2011 4

8/1/2011 41

But this shuold work for all weekstarts like 8/8/2011, 8/15/2011, 8/22/2011, 8/29/2011 any year it should work.

Regards

Anand

Week start selection

Fri, 26 Aug 2011 08:04:33 GMT

Is it numbers of customer disconnected per day in teh choisen week you are looking for?

Then I think the following should work:

If your customer row contain the following fields

customer_id

Date_for_disconnect

weekstart(date_for_disconnect) as Week_start

A listbox on select Week_start let you choose the week

And a chart/diagram displaying

Date_for_disconnect

count(customer_id)

Week start selection

sushil353 — Fri, 26 Aug 2011 08:07:58 GMT

Yup.. i get it

make two variables wStart and wEnd assign wStart= weekstart(DATE) and wEnd= weekstart(Date)-7

then in your chart sum({<DATE={">=$(wEnd)<$(wStart)"}>} Customer)

I hope you will get the idea..

HTH

Week start selection

its_anandrjs — Fri, 26 Aug 2011 08:13:47 GMT

Hi,

Thanks yes right you understand it but iwant to display that ids on that perticular dates like

8/7/2011 22

8/6/2011 15

8/5/2011 10

8/4/2011 8

8/3/2011 5

8/2/2011 4

8/1/2011 41

On 8/7/2011 there is 22 person disconnect but i want to display its IDS like in any Straight table like

8/7/2011 ID01

8/7/2011 ID02

8/7/2011 ID03

.....

....

like ways all

Thanks

Anand

Week start selection

Fri, 26 Aug 2011 08:16:55 GMT

Then the display should be without the count function

And a chart/diagram displaying

Date_for_disconnect

customer_id

Week start selection

its_anandrjs — Fri, 26 Aug 2011 08:19:50 GMT

Hi,

But how only for this dates of selection from 8/8/2011

8/7/2011 22

8/6/2011 15

8/5/2011 10

8/4/2011 8

8/3/2011 5

8/2/2011 4

8/1/2011 41

for below six dates only and it should work for all week start.

Let me know

Regards

Anand

Week start selection

christian77 — Fri, 26 Aug 2011 08:22:54 GMT

Hi:

There is a funktion week() that gives the number of the week in a year.

With set analysis Year={‘$(CurrentYear)’}, Week={‘CurrentWeek’}, Date={‘<=$(CurrentDate)’}, right after you have created those 3 variables.

Week start selection

Fri, 26 Aug 2011 08:24:47 GMT

Does your customer table contain these fileds?

customer_id

Date_for_disconnect

weekstart(date_for_disconnect) as Week_start

Then a listbox on the field Week_start let you choose the week (8/1/2011, 8/8/2011 etc)

And a chart/diagram displaying

Date_for_disconnect

customer_id

will show only the dates in the selcted week due to the fact that both the weekstart date and the "real" date is in the customer table

Week start selection

its_anandrjs — Fri, 26 Aug 2011 08:42:09 GMT

Hi,

Yes there is

customer_id

Date_for_disconnect

weekstart(date_for_disconnect) as Week_start

is available and the list box for weekstart is available but condition is that i need to select only sinlge week start on the basis of that like i select 8/8/2011 (Weekstart)

then a straight table work acording to below dates to be display like

8/7/2011

8/6/2011

8/5/2011

8/4/2011

8/3/2011

8/2/2011

8/1/2011

for this dates and its customer_id

I think you almost correct please help for this

Regards

Anand

Week start selection

its_anandrjs — Fri, 26 Aug 2011 08:44:32 GMT

Hi,

But there is a single selection only for weekstart on the basis of that.

Regards

Anand

Week start selection

Fri, 26 Aug 2011 08:52:23 GMT

Hm, I dont't understand what you mean.

From a listbox you can choose several values (several at once, Ctrl+select to add more to the selection). But I'm not sure this is what you are thinking about?

Week start selection

christian77 — Fri, 26 Aug 2011 08:58:37 GMT

Well, I use set analysis a lot.

If you are going by selections, use week(date) in the script or set it as an expresion in a list box.

Re: Week start selection

its_anandrjs — Fri, 26 Aug 2011 09:13:03 GMT

Hi All,

See the attached sample on that by default i select 8/8/2011

and in table box it is display only the dates like

Date

8/8/2011

8/9/2011

8/10/2011

8/11/2011

8/12/2011

8/13/2011

8/14/2011

but how can i get dates like

8/7/2011

8/6/2011

8/5/2011

8/4/2011

8/3/2011

8/2/2011

8/1/2011

it is understood by default it select that days but how get the above dates.

Regards,

Anand

Week start selection

Fri, 26 Aug 2011 09:31:13 GMT

You want to display the dates in the week before the week you select?

The easiest is to select the week before.

Or you can use WeekEnd instead of WeekStart (displays Sundays, if you want to show Monday add one day to your listbox display).

It seems like it is only the 6 days before, is that significant?

Re: Week start selection

its_anandrjs — Fri, 26 Aug 2011 09:48:19 GMT

Hi,

Yes it should be reverse of the dates just opposite it looks right now reverse of that, means go back to six days.

Regards,

Anand

Re: Week start selection

Fri, 26 Aug 2011 09:52:11 GMT

Hi,

Please see the attached sample can help you.

Cheers.