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

[girishsrini]

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

[YoussefBelloum]

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

[girishsrini]

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.