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: 
Not applicable

needs extra modification

Hi,

so I have a measure in a table and I am trying to connect it to another measure in the same table

so I have reached this statment but it still needs tiny modification which I can't figure out yet ...hoping someone here can help

Top(sum({$<[OnHand History Transaction.AsOfDate]= >}

            (([OnHand History Transaction.Cost]*[OnHand History Transaction.Total])

           + ([OnHand History Transaction.Core]*[OnHand History Transaction.Total]))))

the red part is the place that needs more modification because instead of ignoring the current selection of that dimension I want it to use the selection of a measure which is calculated as follows

max(if([OnHand History Transaction.AsOfDate]<=

           makedate([Historical Year.Year],[Historical Month.Month],[Historical Day.Day]),

           [OnHand History Transaction.AsOfDate]

        ))

so any suggestions how to do the merge

thanks in advance

0 Replies