Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Masi_Sahargahi
Contributor III
Contributor III

how to handle semi additive measures in qlikview

Hello all!

I have a problem with handling semi additive measures in Qlikview which i couldn't find a solution for.

can any body help me out of this:

i have a table which stores customer's last account balance.i want to show the last balance for every level of date hierarchy that user filters(year,quarter,month,day).

tip:just when a transaction occurs and affects on customer balance,a record(last balance) will be inserted in table,meaning we don't have all the last balances for every day in table.

any help would be highly  appreciated!

21 Replies
Masi_Sahargahi
Contributor III
Contributor III
Author

for example for account_id=2

the last balance has inserted in 20150101 but when i filter Feb-2015 i would like to see its last balance to in summation.

in the other word : i want to have sum of every account_id's last balance in any time

tresesco
MVP
MVP

I would go with :The As-Of Table way.