Need help with straight table

[Frank_Hartmann]

Hello community I need your help.

I have a table which was working fine the whole year 2017 until CW51/2017. In CW52/2017

I updated my data but suddenly I had wrong values in my table. I was searching and searching for the

error but was not able to find the error. I would really appreciate if someone could have a look into this.

If you open the app you will find the detailed description of what is wrong and how it should look  like.

Many thanks in advance

Best regards

Frank

[Frank_Hartmann]

But it is very strange that it was working until CW 51/2017.........

[sunny_talwar]

To do this for QV11.2... I have added a new table at the very end of your load script

Sort:

LOAD WeekDiff,

RowNo() as Sort

Resident MasterCalendar

Order By WeekDiff;

and then use this expression

sum(aggr(if(sum(aggr(rangesum(above( sum({$<Flag={'1'},ExcludedFlag_Vorgang_v2={'1'}>}Daten_Vorgang_Sonderauswertung),0,4)),Werkstatt_Vorgang_Sonderauswertung, Sort))>vVorgänge4KW and

(sum(aggr(rangesum(above( sum({$<Flag={'1'},ExcludedFlag_Vorgang_v2={'1'}>}Daten_Vorgang_Sonderauswertung),0,1)),Werkstatt_Vorgang_Sonderauswertung,Sort)))>vVorgangKW,1,0),

Werkstatt_Vorgang_Sonderauswertung,Sort))

[Frank_Hartmann]

You are the king 🙂

Cant tell you how much I appreciate your help.

I just replaced WeekDiff with WeekdayLongName in the formula and it worked 🙂

[sunny_talwar]

So then you do have QV12... because this expression won't work in QV11.2 (unless something changed)

[Frank_Hartmann]

No, Im using V11.20

But anyway! Thanks a lot for the hint with the WeekDayLongName Field 🙂

[sunny_talwar]

Oh okay, I see what you mean... WeekDayLongName is sorted in the right order I guess

[Frank_Hartmann]

But the WeekDiff Filed is also sorted in the correct order.

But I have no clue why it was no longer working after CW51/2017

[sunny_talwar]

See the messed up sorting

The table box was sorted by WeekDiff's load order

[sunny_talwar]

For some reason shows up here

[Frank_Hartmann]

Ohhhh, yeah!

Now its clear to me 🙂

Thx a lot for your effort