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

[stabben23]

remove section access

[sunny_talwar]

What is the user id and password to open your app?

[Frank_Hartmann]

Sorry, I updated the qvw!

[sunny_talwar]

Still asking for User ID

[Frank_Hartmann]

Sorry I removed section access but forgot to reload the data.

Now It should work

[stabben23]

Works now

[sunny_talwar]

If you have QV12 or above... try this

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

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

Werkstatt_Vorgang_Sonderauswertung,(WeekdayLongName, (NUMERIC))))

[Frank_Hartmann]

No. Im using V11.20

Any chance to get it work with this version?

Thank you very much for helping 🙂

[sunny_talwar · Accepted solution]

Sort WeekDay in ascending order in the script....

the above expression was giving the right number, but I wanted to use WeekDay instead of WeekdayLongName

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

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

Werkstatt_Vorgang_Sonderauswertung,(WeekDiff, (NUMERIC))))