topic Suggestion in QlikView

Suggestion

Tue, 13 Sep 2011 05:21:28 GMT

Hi all,

I have a pivot table with the following dimensions and expression:

Dimensions:

BranchCode
AccountNumber

Expression:

Sum(Aggr(FirstSortedValue(EndingBalance,-TrxDate),AccountNumber,BranchCode))

My goal here is to get the last Ending Balance of an account and and sum it up base on brach code. Is there another way/expression aside from my current expression that will give me the same result but more optimized because my worry with my current expression is if I have more that 60M worth of data my dashboard will slow down..

Thanks!!!

Suggestion

its_anandrjs — Tue, 13 Sep 2011 05:26:18 GMT

Hi,

I suggest no worry because your pivot has few Dimensions and expression so it is not any problem when increase the no of Expression and Dimensions untill it is ok.

HTH

Regards

Anand

Suggestion

Tue, 13 Sep 2011 05:37:11 GMT

I replicated this using 4 dimensions with 11M+ worth of data but the chart took approximately 30 seconds to load. so now I'm looking for other way...

Thanks!

Suggestion

suniljain — Tue, 13 Sep 2011 05:49:15 GMT

If you are using complex expression in chart it wil take time to display content. so i will suggest to implement calculation in background.

Re: Suggestion

its_anandrjs — Tue, 13 Sep 2011 05:50:46 GMT

Hi,

If you are using Dimension and Expression like this for this i suggest to use the variables for expression and use this variables in your chart. Use as much as possible the variables it will decresse the loading time like

vSum = Sum( Yourfield )

vCount = Count( Expressions )

vTotal = Count( Check condition )

like ways other also it will depends on your expression and dimension, use this variables in chart.

HTH

Regards

Anand

Suggestion

Tue, 13 Sep 2011 06:53:15 GMT

but everytime I put FirstSortedValue(EndingBalance,-TrxDate) in the script i get an Invalid Expression error.. I already put a Group by clause..