6 Replies Latest reply: Jun 28, 2017 1:40 AM by Kevin Nagel RSS

    Formula within set analysis

    Kevin Nagel

      Hi all,

       

      i'm new to the Forum and very excited about QlikView.

       

      Currently I have a Problem with using a formula within a set Analysis.

       

      With disctinct data it Looks like this:

       

      = num(
      sum(
      {<
      Kalender.Datum = {"31.03.2017"}
      >}
      YE_WE_PosFAU.E_WE_LieferMenge)
      , '###.##0')

       

      This spits out the right result!

       

      But if I ask like this:

       

      = num(
      sum(
      {< Kalender.Datum = {$(max(YE_WE_PosFAU.PrüfDatum,3))}
      >}
      YE_WE_PosFAU.E_WE_LieferMenge)
      , '###.##0')

      it doesn't return the right numbers.

       

      I have checked, and

       

      =max(YE_WE_PosFAU.PrüfDatum,3))
      is the 31.03.2017

       

      Why is it, that the formula won't be calculated correctly?

       

      Thank you in advance.

       

      Kevin