topic Re: Reg: Display current week and previous week in QlikView

Reg: Display current week and previous week

Tue, 08 Apr 2014 06:53:45 GMT

Hi All,

I have bar chart, for that i need to display the current week data as one bar and the previous week data as another bar by default. when we select a date,it should consider the week of that date as current week and the previous week of that as previous. how can i achieve the same.

Thanks in advance

Re: Reg: Display current week and previous week

sujeetsingh — Tue, 08 Apr 2014 07:03:52 GMT

Reena

Just have look to this thread

http://community.qlik.com/thread/72802

Re: Reg: Display current week and previous week

sujeetsingh — Tue, 08 Apr 2014 07:05:45 GMT

Even this too is helpful

http://community.qlik.com/thread/70549

Re: Reg: Display current week and previous week

its_anandrjs — Tue, 08 Apr 2014 07:06:12 GMT

Write

Dimension :- week

Expression Current Week:- =sum({<Week={$(=(Week))>} Sales Val)

Expression Previous Week:- =sum({<Week={$(=(Week-1))>} Sales Val)

Regards

Re: Reg: Display current week and previous week

Tue, 08 Apr 2014 07:09:57 GMT

Hi Reena,

Derive week field from your date and follow Anand method

Re: Reg: Display current week and previous week

nizamsha — Tue, 08 Apr 2014 07:15:22 GMT

sum(Date={"$(=Max(MyDate))"}) for Current Date say its Sunday

sum({$<Date={"$(=only(MyDate)-7)"}>}sales) Previous Date Last Sunday

Re: Reg: Display current week and previous week

Tue, 08 Apr 2014 07:16:10 GMT

Hi,

First generate Week field from your table script by using this

Week(DateField) as Week

and Follow anand's post

Re: Reg: Display current week and previous week

Tue, 08 Apr 2014 08:47:45 GMT

Hi,

but i need to take the dimension as Date, when i select the Date the corresponding week information and the previous week information should display.

i tried the above ,but its not working .dont kno why..

Thanks...

Re: Reg: Display current week and previous week

its_anandrjs — Tue, 08 Apr 2014 09:33:24 GMT

Update i think it will give you correct out put for Date field

Take a Date field as dimension and in expression write

For current week =sum({< Week = {'$(=Max(week(Date)))'}>} Sales)

For Previous week =sum({< Week = {'$(=Max(week(Date))-1)'}>} Sales)

Hope this helps

Re: Reg: Display current week and previous week

jagan — Tue, 08 Apr 2014 09:49:27 GMT

Hi,

Try like this

=Sum({<Week=, Year=, Month=, Quarter=, Date={'>=$(=WeekStart(Max(Date), -1))<=$(=Date(Max(Date)))'}>} MeasureName)

Regards,

Jagan.

Re: Re: Reg: Display current week and previous week

Tue, 08 Apr 2014 09:57:18 GMT

Hi,

Kindly find the attached.

Re: Re: Re: Reg: Display current week and previous week

Tue, 08 Apr 2014 10:11:02 GMT

Use these expressions inplave of your expressions

CurrentWeek

= sum({<I_PLANT={'Autofit Daruhera Plant'},Week={$(=Max(Week))}>}

I_CURRENT_REQ_QTY)

PrevWeek

= sum({<I_PLANT={'Autofit Daruhera Plant'},Week={$(=Max(Week-1))}>}

I_CURRENT_REQ_QTY)

Re: Re: Reg: Display current week and previous week

Tue, 08 Apr 2014 10:23:54 GMT

Hi,

Now its showing the Max Week Default, but when i select any other filters other than 'Week' only the current month data is displaying..

Re: Re: Re: Reg: Display current week and previous week

its_anandrjs — Tue, 08 Apr 2014 10:28:01 GMT

Your Current Expression

=sum({<Week={$(=Max(Week))},I_PLANT={'Autofit Daruhera Plant'}>} I_CURRENT_REQ_QTY)

and Previous expression

= sum({<I_PLANT={'Autofit Daruhera Plant'},Week={$(=Max(Week)-1)}>} I_CURRENT_REQ_QTY)

Re: Re: Re: Reg: Display current week and previous week

its_anandrjs — Tue, 08 Apr 2014 10:31:51 GMT

I suggest it is due to you select in expression data only for I_PLANT={'Autofit Daruhera Plant'} may be due to this please check this filter.

Re: Reg: Display current week and previous week

israrkhan — Tue, 08 Apr 2014 10:38:41 GMT

Hi Reena,

Check the Attached..

May it Help..

Khan

Re: Re: Reg: Display current week and previous week

Tue, 08 Apr 2014 11:15:29 GMT

hii,

i have tried this.hope its workin nw..

=sum({<Week={$(=Max(Week))},Cust_Week=,@_Date=,Year=,Day=,@_Month=,I_PLANT={'Autofit Daruhera Plant'}>} I_CURRENT_REQ_QTY)

= sum({<I_PLANT={'Autofit Daruhera Plant'},Week={$(=Max(Week-1))},Cust_Week=,@_Date=,Year=,Day=,@_Month=>} I_CURRENT_REQ_QTY)

Re: Re: Re: Reg: Display current week and previous week

its_anandrjs — Tue, 08 Apr 2014 11:35:10 GMT

Yes correct bu using this way you by pass the selections for this fields

Cust_Week=,@_Date=,Year=,Day=,@_Month=

=sum({<Week={$(=Max(Week))},Cust_Week=,@_Date=,Year=,Day=,@_Month=,I_PLANT={'Autofit Daruhera Plant'}>} I_CURRENT_REQ_QTY)

= sum({<I_PLANT={'Autofit Daruhera Plant'},Week={$(=Max(Week-1))},Cust_Week=,@_Date=,Year=,Day=,@_Month=>} I_CURRENT_REQ_QTY)