Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
kuba_michalik
Partner - Specialist
Partner - Specialist

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.

Not applicable
Author

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.