Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MalcolmCICWF
Creator III
Creator III

Total & Remaining Amount based off specific date

Could anyone lend me some help/advice on laying out my data in the below format and example? I am not sure on the best way to go about this via Dimensions and Expressions within a Straight or Pivot table...

I have a couple cyclic groups that my end users would like to sort on. They need a totals column as seen by "Remaining ERCs as of (date)", and then they need ERC Month/Year laid out horizontally to show just how much ErcAmount remains in each.

If I can achieve this, I also need to find a way I can select or enter which ERC Month/Year the sum of the Totals begin In my example it is 1/1/2016, I would like to be able to change that to any date... Thoughts?

Capture.JPG

10 Replies
sunny_talwar

I am not sure why you deleted you last post, but since I have it already prepared, I am going to share my sample anyway

See if this helps now (Driven by the Inputbox)

Capture.PNG