topic Re: Dynamic pick dimension in QlikView

Dynamic pick dimension

Fri, 10 Apr 2015 13:41:07 GMT

Hy Community,

I have follow the example in What's new in QlikView 11 application to manage dynamic pick dimensions.

This solution is powerfull but where are his limits?

I created 1 pick dimension for account / brand / ... and 1 pick metrics for value / units

I analyse this datas in YTD-1, YTD, YTD Growth +/- , YTD Growth %, YTD-1, MAT, MAT Growth +/- , MAT Growth %, MMT-1, MMT, MMT Growth +/- , MMT Growth %

With this configuration, I explose the calculation time because I think I have too much expression in my straight table which has approximately 5000 rows on my first dimension.

I want to known where is the limits of use pick dimension and if the code of the What's new in QlikView 11 application is optimized :

- =SubStringCount(Concat(_dimension, '|'), 'Region') for dimension display condition

- =SubStringCount(Concat(_metricsNo, '|'), 1) for expression display condition

Thank you in advance for your feedback

Re: Dynamic pick dimension

Mon, 13 Apr 2015 07:44:04 GMT

Hy Community,

Anyone has an idea?

Thank you in advance for your help

Re: Dynamic pick dimension

Tue, 14 Apr 2015 15:12:07 GMT

Hy community,

I'm feeling alone

It's seems that the slowness becomes when you use a lot of conditional expressions.

Have you try to use conditional expressions in how many expressions?

Thnak you in advacne for your help!

Re: Dynamic pick dimension

ramoncova06 — Tue, 14 Apr 2015 15:21:16 GMT

Thibaut,

it really depends on the granularity of the dimensions that you have and why type of metric are you using

if you are using a count distinct for a serial number, ip, transaction, etc. and you have millions of them then it does become real slow.

In a nutshell this is like all other QV reports where the response time is relative to the the granularity and the expression being used

Re: Dynamic pick dimension

Tue, 14 Apr 2015 15:34:03 GMT

Thank you Ramon for your response

I'm agree with you but in my example it' very simple and I don't understand:

- I have ~500000 rows of sales

- My dimension is by customers ~5000

- I just set analysis for period YTD, MAT, MMT

I tried two things :

- Display my straight table without conditionnal expressions (48 expressions) => 702ms to calculate and the display is instantly

- Display my straight table with conditionnal expressions (12 expressions) => 78ms to calculate and the display is approximatively 3 to 4 seconds.

I have optimized my conditonal expression with integer to save time but it's not significant.

Sorry but I don't understand

Thank you in advance for your help

Re: Dynamic pick dimension

ramoncova06 — Tue, 14 Apr 2015 15:52:25 GMT

I would have to see your data in order to provide a better insight as to what is causing it, my first thought would think that Qlikview is caching the one without conditional expressions, though one expression getting calculated on 702ms and the other one in 78ms kind of defines that the expression is taking less to run

what kind of schema do you have a star, snowflake or link table ?

Re: Dynamic pick dimension

Tue, 14 Apr 2015 15:58:46 GMT

I have a link table between sales and customers, I try to optimized them but I think I can not over