I explain what I would like to achieve in Qlikview, I have a below data,
|Britem||Creation Date||Line Id||Qty|
I would like to calculate the Qty and show it as below
|Britem||Creation Date||Line Id||Qty||Expected Qty|
Can anyone please let me know, how can I achieve the expected Qty using set analysis or other expressions.
I've been looking through your answers to Qlik Community Questions on Cumulative Sum.
Would you be able to help with this one?
We're having troubles trying to get the cumulative percentage in a pivot table?
Please see this thread:
is it possible to calculate the cumulative sum for a further grouping-dimension.
Let say i have a field with two categories and i want to display the cumulative qty in a line chart with two lines
How do i adjust the expression to consider the grouping dimension?