topic Need help with straight table in QlikView

Need help with straight table

Frank_Hartmann — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Need help with straight table

stabben23 — Wed, 17 Jan 2018 14:54:33 GMT

remove section access

Re: Need help with straight table

sunny_talwar — Wed, 17 Jan 2018 14:54:39 GMT

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

Re: Need help with straight table

Frank_Hartmann — Wed, 17 Jan 2018 15:00:30 GMT

Sorry, I updated the qvw!

Re: Need help with straight table

sunny_talwar — Wed, 17 Jan 2018 15:06:43 GMT

Still asking for User ID

Re: Need help with straight table

Frank_Hartmann — Wed, 17 Jan 2018 15:07:24 GMT

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

Now It should work

Re: Need help with straight table

stabben23 — Wed, 17 Jan 2018 15:07:58 GMT

Works now

Re: Need help with straight table

sunny_talwar — Wed, 17 Jan 2018 15:20:47 GMT

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

Re: Need help with straight table

Frank_Hartmann — Wed, 17 Jan 2018 15:22:31 GMT

No. Im using V11.20

Any chance to get it work with this version?

Thank you very much for helping 🙂

Re: Need help with straight table

sunny_talwar — Wed, 17 Jan 2018 15:24:46 GMT

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

Re: Need help with straight table

Frank_Hartmann — Wed, 17 Jan 2018 15:25:52 GMT

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

Re: Need help with straight table

sunny_talwar — Wed, 17 Jan 2018 15:29:12 GMT

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

Re: Need help with straight table

Frank_Hartmann — Wed, 17 Jan 2018 15:34:10 GMT

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 🙂

Re: Need help with straight table

sunny_talwar — Wed, 17 Jan 2018 15:49:06 GMT

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

Re: Need help with straight table

Frank_Hartmann — Wed, 17 Jan 2018 16:02:02 GMT

No, Im using V11.20

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

Re: Need help with straight table

sunny_talwar — Wed, 17 Jan 2018 16:04:32 GMT

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

Re: Need help with straight table

Frank_Hartmann — Wed, 17 Jan 2018 16:07:03 GMT

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

Re: Need help with straight table

sunny_talwar — Wed, 17 Jan 2018 16:17:25 GMT

See the messed up sorting

The table box was sorted by WeekDiff's load order

Re: Need help with straight table

sunny_talwar — Wed, 17 Jan 2018 16:18:18 GMT

For some reason shows up here

Re: Need help with straight table

Frank_Hartmann — Wed, 17 Jan 2018 16:25:48 GMT

Ohhhh, yeah!

Now its clear to me 🙂

Thx a lot for your effort