Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

meetmrudul
Contributor II

Performance Impact

Hi All,

Can anyone of you please tell me which one is better to use in Set Analysis Expressions -

Only()

Maxstring()

Concat()

Which one will have least impact on Performance.

Please assist on same.

Regards,

MK

6 Replies
cesaraccardi
Valued Contributor

Re: Performance Impact

Hi,

Can you provide an example of whatyou would like to achieve?

manojkulkarni
Valued Contributor II

Re: Performance Impact

use of above function dependent on your requirement and on what type field being used.

meetmrudul
Contributor II

Re: Performance Impact

Suppose I have a requirement where I want to write condition like -

Maxstring({<field=P({<$(var1)>}field2),$(var2), field3=>}field4)

In this case, which expression will be having least impact on Performance, whether i should use -

Only()

Maxstring()

Concat()

Regards,

MK

cesaraccardi
Valued Contributor

Re: Performance Impact

Ok thanks, I think I understand now.

If the goal is to reduce a list of text values to a single value then I would suggest to use Only() as it is a basic aggregation function and doesn't have any additional processing to find out what is the maximum value, like maxstring() for example.

Now regarding Concat() the result would not be the same as Only() unless if you include a DISTINCT parameter inside the function which I suspect (not 100% sure) will be less performant than Only().

Hope this helps,

Cesar

cesaraccardi
Valued Contributor

Re: Performance Impact

By the way, I am assuming all the values on the field you are aggregating are the same. Please let me know if this is not the case.

rajeshvaswani77
Valued Contributor III

Re: Performance Impact

Overall the Set Expression will give you a performance benefit.

thanks,

Rajesh Vaswani

Community Browser