7 Replies Latest reply: Mar 21, 2016 6:15 AM by Tresesco B RSS

    Getting Max Value of a Field

    Christoph Hebig

      Hi Community,

       

      I searched for this a lot now and I also found a few threads that all show me the same method (like this one):

       

      Find out max numerical value in a QlikView script | Qlik Community

       

      When using the described method, I get a value but it is not the highest in my dataset.

      For more explanation:

      I have a field called ExpNr which contains only numerical values (at the moment from 1 to 9) so I expect the value 9 for my script:

       

      TempMaxExpNr:

      Load Max(ExpNr) as MaxExpNr resident Experiment_Info;

       

      Let vExpMax = FieldValue('MaxExpNr', 1);

       

      But instead of 9, I get the value 3.

       

      I hope someone can help me with my problem

       

      Regards

      Chris