Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner
Partner

Help with trial balance expression

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?

Kindly advise ( @sunny_talwar , @rwunderlich )

I can walk on water when it freezes
1 Solution

Accepted Solutions
sunny_talwar

16 Replies
sunny_talwar

ali_hijazi
Partner
Partner
Author

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

I can walk on water when it freezes
sunny_talwar

Would you be able to share a sample where we can see this?

ali_hijazi
Partner
Partner
Author

Hi @sunny_talwar 
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

I can walk on water when it freezes
sunny_talwar

You want Oct 2011 to be 0? but right now I only see Oct 2010, Nov 2010, Dec 2010, Jan 2011 in the chart once I select Company Code 010

ali_hijazi
Partner
Partner
Author

Hello @sunny_talwar 
check attached

I can walk on water when it freezes
sunny_talwar

I still don't see Oct 2011?

image.png

ali_hijazi
Partner
Partner
Author

scroll the chart to the right

I can walk on water when it freezes
ali_hijazi
Partner
Partner
Author

Hello @sunny_talwar 
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

I can walk on water when it freezes