4 Replies Latest reply: Jul 19, 2016 7:38 AM by Henric Cronström RSS

    lookup based on dimension

    Nima Vahedi

      Hi,

       

      I have a set of transaction data in a stock market. my goal is to find the latest transaction date in Persian (Jalali) format. since qlikview doesn't recognize the date format, I've bound Persian format to Gregorian one, and I'm trying to lookup Persian date with maximum Gregorian date for each customer as dimension. However my tries has been failed.

      I've tried combination of only and max in set analysis but it failed since set analysis doesn't care about dimension...

      I've also tried FirstSortedValue to no avail since it could be more than just one transaction in the last date.

      I'd be glad if anyone knew a solution to the problem.

      PS. I have attached a sample file...