13 Replies Latest reply: Jan 5, 2015 9:04 AM by Zhihong He RSS

    how to select only one element based on another selection

    Zhihong He

      Hi, I have a problem to create a button select an element from the result of another selection.

      Target:

      1. Select the latest "Date".

      2. Based on the latest Date, the column Name can have multiple result.

      3. Select only one Name from step 2.

       

       

      Is there some thing like below:

      somefunction({<Date={'$(=only(max({<Date={"<=01-10-2014 0:00:00"}>}Date)))'}>}Name)

      that can select only one (the top one) Name from the Name list?

      This is like to use array[1] in php, but I do not know how to select it in qlikview.

       

      Can any one help?

      THanks very much