Discussion board where members can learn more about Qlik Sense Advanced Authoring.
I need help calculating a measure in a pivot table which depends on 2 other measures.
The calculation is "The minimum number of cells (beyond the current column) in row A such that the sum of the values in row A exceeds the value of row B in the current cell)
See attached image.
Is this possible in a pivot table?
Here is the load script:
Load * inline [Part,Measure,Date,ValueC1,B,8/20/2019,21C1,B,8/21/2019,18C1,B,8/22/2019,20C1,B,8/23/2019,20C1,B,8/24/2019,13C1,B,8/25/2019,22.5C1,B,8/26/2019,36C1,B,8/27/2019,39C1,B,8/28/2019,39C1,B,8/29/2019,28.5C1,B,8/30/2019,24.75C1,A,8/20/2019,11C1,A,8/21/2019,11C1,A,8/22/2019,11C1,A,8/23/2019,11C1,A,8/24/2019,11C1,A,8/25/2019,16.5C1,A,8/26/2019,16.5C1,A,8/27/2019,16.5C1,A,8/28/2019,16.5C1,A,8/29/2019,16.5C1,A,8/30/2019,24.75];
[PivotData]:Generic Load Part, Date, Measure, Value Resident [Data];
Drop table [Data];
Should be possible using before/after functions. (and maybe above)
share some sample data and we can try and help
Load Script added to original post