topic Quarterly grouped data shows wrong value, whereas data is accurate if all weeks are shown in a single table in Archived Groups

Quarterly grouped data shows wrong value, whereas data is accurate if all weeks are shown in a single table

girishsrini — Tue, 22 Jul 2025 17:59:49 GMT

Hi,

Good-Day.

I have a dashboard in QlikSense, it shows data at a weekly level. Data is fine when its shown for all weeks in a tabular form. However, if its grouped for quarters, the data is wrong from 2^nd quarter.

Below is the screenshot and attached sample QVF built for discussion. Please suggest if expression needs to be changed.

Regards,

Girish

Re: Quarterly grouped data shows wrong value, whereas data is accurate if all weeks are shown in a single table

YoussefBelloum — Tue, 20 Feb 2018 14:09:39 GMT

Hi,

when you say DATA IS GROUPED BY QUARTER, you mean on the right tables ?

I don't see wrong valus compared with your source..

Also, you can add this to your script to have the Weekdate and the Quarters, it will be easier to make the conditions on the expressions:

MakeWeekDate(Year,Week) as WeekDate,

'Q' & CEIL(NUM(MONTH(MakeWeekDate(Year,Week)))/3) AS CALENDAR_QUARTER

Re: Quarterly grouped data shows wrong value, whereas data is accurate if all weeks are shown in a single table

girishsrini — Wed, 21 Feb 2018 05:51:10 GMT

Hi Youssef,

Thanks for your reply.

Yes the right tables are grouped for quarters. Please note that there is no dates used for identifying quarters, there is week number and have grouped weeks to categories quarters.

Data looks fine at glance but from Week 19(Quarter Q2 table) is wrong.

I am wondering may be because expression has above() and rangesum() its not picking right value. Can there be alternative way to group this weekly data for quarters.

If possible, Please check the app for variable and expressions.