Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
I would go with :The As-Of Table way.