Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hello got a QVF file in which I'm creating a pivot table for trial balance
the result is 100% correct (open attached qvf and select the company code 010 and select A/P-A/R accounting)
You see the opening balance, the activity, and closing balance and how the opening balance of a month is the closing balance of the previous month...
Now if you select Nov 2010 the numbers are still correct however I can still the remaining months to the right
and that's because of the variable I'm using which is $(vL.TrialBalance.OpeningBalance) which I'm using in the expressions for opening balance, and closing balance
is there a way to hide the months and show only selected ones?
so you only added avg(1)?
ok this works so good with carry-forward-accounts
what if I want something similar but for non-carry forward accounts that reset on period 1 always
the variable that you fixed calculates the cumulative amount per account prior to the minimum month selected
then I add to it the activity per month to get the closing balance
however some accounts like the ones that start with 6 and 7 I want if I select a month in the middle of the fiscal year to work as the one fixed but gives zero for the starting period
hope you can help here
check attached sample
select 010 as company code
now in october 2010 the opening balances are zero
what I want to achieve is to have the revenues and expenses be zero in Octo 2011 and then continue on summing the cumulative
if you check the month year filter you have all months for 2 fiscal years
you need to scroll the chart from the bottom to the right to see the remaining months on the chart