Week with total

[viveksingh]

Hi All,

I have 3 dimension and two measures. And another dimension as date on top in pivot table.

I Want to sumup all weekdays data and display as Total for wee. And again the next week days dates should come. Som how I displayed total week. but couldn’t sum up the data

below is screen shot

sorry for the image, I couldn’t attach qvw.

Here, Total Week field shows zero. Instead of sum up weekdays data.

[viveksingh]

‌stalwar1‌ can you help me on the above

I Saw your post simil to my requirement

https://community.qlik.com/thread/306966

[qlikviewwizard]

Hi vivek pv

Please try like this.

[viveksingh]

‌Thanks for reply arjun. Here I need data on daily basis. I mean the date should be continuos and in plac of weeken, we need one total. and followed by next date.

[qlikviewwizard]

Hi viveksingh

Is this you want?

[viveksingh]

‌yes Arjun this is what I’m looking for.  Can you confirm 1/4/2009 and 1/5/2009 is weekend?

and also i have 3 dimentiins like hierarchy.infront of Region field I have group, type as other dimension.

Group1	GRoup 2	Region
G1	1	GERMANY
G1	1	JAPAN
G2	A	NORDIC
G2	B	SPAIN

I Just considered the data from your applicatio.

[viveksingh]

‌we don’t need weekstart field which is on top of pivot

[qlikviewwizard]

Hi viveksingh

Please check this.

[qlikviewwizard]

Hi viveksingh

I included both the dimensions in the data.

Data:

LOAD *,WeekEnd(Date) as WeekEnd;

LOAD Date,Group1,GRoup2,

    Region,

    [Product Type],

    AFYP,

    Cases

FROM

Community\1.xlsx

(ooxml, embedded labels, table is Sheet1);

[viveksingh]

‌Thanks arjun for your efforts. As I couldn’t check your application in my mobile, I checked it in the night. It was good with your data. But where as with my data, I’m not getting totals.

Actually, I don’t have dates for weeken days i.e, Saturday nd Sunday. So I generated date like below

load date(MinDate +IternNo() -1) as PROP_REG_DATE

while(MinDate+iterNo() -1)<=num(MaxDate);

load

Min(PROP_REG_DATE) as MinDate,

Max(PROP_REG_DATE) as MaxDate

resident table1;

below is the screen shot for how I’m getting the data