topic Re: extremely slow table in QlikView

extremely slow table

Tue, 21 Oct 2014 07:58:26 GMT

Hello everyone,

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

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?

Re: extremely slow table

jonathandienst — Tue, 21 Oct 2014 08:18:55 GMT

It may not be the cause, but the expression in your variable looks a little odd. I think this

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

should read

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

Have you tested the expanded expression as well?

Regards

Jonathan

Re: extremely slow table

kuba_michalik — Tue, 21 Oct 2014 08:40:28 GMT

Hard to say without knowledge of the data model etc. What I can suggest, is to eliminate all possible sources of the slowness step by step. Like, first: convert all dollar sign expansion to explicit formulas, see if it helps, second: start cutting parts of the set analysis expression one by one. All the time monitor the calc time, and you should find the cause soon. Mind though, it does not necessarily mean you would be able to speed it up. Some calculations just take time even in QV, especially if you have tons of data in that app.

Re: extremely slow table

Tue, 21 Oct 2014 10:24:40 GMT

Finally, I have found a solution. My problem was that I have calculated dimensions(it combines two dimensions into one) in this table. I created this dimension in script and used it in chart and now it works way faster. Thanks all for advices.

Re: extremely slow table

garyhowjtc — Wed, 07 Mar 2018 16:15:29 GMT

‌Hi, how did you do that?

Re: Create calculated dimension in load script from an associated table in data manager?