Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Frank_Hartmann
Master II
Master II

Need help with straight table

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

1 Solution

Accepted Solutions
sunny_talwar

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))))

View solution in original post

19 Replies
stabben23
Master
Master

remove section access

sunny_talwar

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

Frank_Hartmann
Master II
Master II
Author

Sorry, I updated the qvw!

sunny_talwar

Still asking for User ID

Frank_Hartmann
Master II
Master II
Author

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

Now It should work

stabben23
Master
Master

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))))


Capture.PNG


Frank_Hartmann
Master II
Master II
Author

No. Im using V11.20

Any chance to get it work with this version?

Thank you very much for helping 🙂

sunny_talwar

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))))