topic Re: Week with total in QlikView

Week with total

viveksingh — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Week with total

viveksingh — Mon, 06 Aug 2018 07:43:30 GMT

‌stalwar1‌ can you help me on the above

I Saw your post simil to my requirement

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

Re: Week with total

qlikviewwizard — Mon, 06 Aug 2018 07:45:01 GMT

Hi vivek pv

Please try like this.

Re: Week with total

viveksingh — Mon, 06 Aug 2018 08:22:46 GMT

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

Re: Week with total

qlikviewwizard — Mon, 06 Aug 2018 08:48:32 GMT

Hi viveksingh

Is this you want?

Re: Week with total

viveksingh — Mon, 06 Aug 2018 09:26:29 GMT

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

Re: Week with total

viveksingh — Mon, 06 Aug 2018 09:27:57 GMT

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

Re: Week with total

qlikviewwizard — Mon, 06 Aug 2018 09:40:47 GMT

Hi viveksingh

Please check this.

Re: Week with total

qlikviewwizard — Mon, 06 Aug 2018 09:42:05 GMT

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);

Re: Week with total

viveksingh — Tue, 07 Aug 2018 01:12:53 GMT

‌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

Re: Week with total

qlikviewwizard — Tue, 07 Aug 2018 01:31:36 GMT

Hi,

Check the options like this.

Re: Week with total

viveksingh — Tue, 07 Aug 2018 02:33:20 GMT

‌perfect . Working fine.

with this, I don’t need weekend dates as wel. I have removed it.

Thanks Arjun for you great effort.

Re: Week with total

qlikviewwizard — Tue, 07 Aug 2018 02:54:34 GMT

Happy to help you viveksingh