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.

[qlikviewwizard · Accepted solution]

Hi,

Check the options like this.

[viveksingh]

‌perfect . Working fine.

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

Thanks Arjun for you great effort.

[qlikviewwizard]

Happy to help you viveksingh