4 Replies Latest reply: Mar 7, 2018 11:15 AM by Gary How RSS

    extremely slow table

      Hello everyone,

           Qlikview optimizer show me, that one of my tables is way more slower than others.

      SLOW1.PNG.png

      Here is the expression(and connected variables) of table

           Expression: $(eZak02(Faktura.Datum={">=$(Today()-$(vZakPos))"}))

           eZak02:

      Num(Sum({$}{<[Nakup prodej.Kategorie]={'Prodej'}

      ,[Typ zbozi_ID]={1},$(=Replace('$1', ';', ','))

      >}[Nakup prodej.Prodejni cena celkem]),'# ##0')

           vZakPos: 360

       

      Any ideas why?