Column calculation in Pivot table stops after 130 lines

Marius_ — Thu, 30 Apr 2020 06:07:35 GMT

Highlight shows column calculation that stops abruptlyHi guys (and guydettes :-))

I am using s running total in pivot to calculate cumulative sales orders. From there I must calculate the remaining Salesorders per day after goods were issued.

I used column calculations to try to keep my formulas easy. So far so good.

But the column calculations stopped abruptly after +- 130 lines, then starts up again at the next plant and stop again after +- 100 lines and so forth.

There is no problem with the running total calculation:

rangesum(above(total Sum({<DocType={'1Salesorder'}>}Quantity), 0, rowno(total)))

But the column calculations acts weird:

if(Column(8)<> Column(9), Column(11),Above(Column(13),1,1))

Please see JPG files

Any idea why this would happen?

Marius

Re: Column calculation in Pivot table stops after 130 lines

rubenmarin — Tue, 28 Apr 2020 14:26:29 GMT

Hi, there is no JPG files.

Re: Column calculation in Pivot table stops after 130 lines

Marius_ — Thu, 30 Apr 2020 07:37:27 GMT

Sorry, new at this

See upload

topic Re: Column calculation in Pivot table stops after 130 lines in QlikView

Column calculation in Pivot table stops after 130 lines

Re: Column calculation in Pivot table stops after 130 lines

Re: Column calculation in Pivot table stops after 130 lines