Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tahreen371
Contributor III
Contributor III

How to add the Old Balance with the Selected Values Balance to get the result

Hello,

Please Help me on this b'coz i have to submit it in next two hours and I'm badly stuck at this as I'm very new to qlik....

I have refered with an example, like if i select data from jan 2015 to Dec 2015 the total of amount in that year is 100 and the Old balance amount before 2015 is for the year 2014 which is also 100.

Hence the Total result should be 200 considering Old Balance and Current selection Balance. 

 

DateYearDoc_NumAmount
01-01-201420141200
30-03-201420142-100
01-01-201520154300
30-12-201520155-200
01-04-201620167500

 

I'm really stuck at this point please help team, I'm very new to Qlik.

I have attached the app and screenshot of the requirement for reference.

2 Replies
jyothish8807
Master II
Master II

Hi Thareen,

Try this. Hope it will help.

Best Regards,
KC
tahreen371
Contributor III
Contributor III

Actually that's not the requirement....  I need to sum account transactions from the beginning of time to the current Year-Month selection  in the Lable of straight table

I have also attached the Screenshot of the requirement. Please assist

 

Regards