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:



      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