Reg: Display current week and previous week

[#1]

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

[sujeetsingh]

Reena

Just have look to this thread

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

[sujeetsingh]

Even this too is helpful

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

[its_anandrjs]

Write

Dimension :- week

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

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

Regards

[#5]

Hi Reena,

  Derive week field from your date and follow Anand method

[nizamsha]

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

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

[#7]

Hi,

First generate Week field from your table script by using this

Week(DateField) as Week

and Follow anand's post

[#8]

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...

[its_anandrjs]

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

[jagan]

Hi,

Try like this

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

Regards,

Jagan.