Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
sabahat_quazi
Partner - Creator
Partner - Creator

Performance issue in Trigger Expression

Hi All,

Observing some strange behavior related to Qlikview performance.

we have a trigger where we need to select list of customers based on certain set analysis filters.

We  came across a situation where for the first iteration the customers to be selected in the list box were around 65K which took around 90 sec.

In the second iteration ,based on a new  filter ( set analysis) the customers to be selected were 90K which took around 17sec.


So ,why was the second iteration with more customers quicker?

Is there any subset caching kind of concept here?



Below is the Expression we are using for your reference:


Trigger Expression for scenario#1:


='(' & concat(Distinct {<Customer={"=sum(Volume)>200"}>} Customer ,'|')  &')'


Trigger Expression for scenario#2:

='(' & concat(Distinct {<Customer={"=sum(Volume)>100"}>} Customer ,'|')  &')'


Has anyone come across such a scenario?

Thanks and Regards,

Sabahat

1 Reply
sunny_talwar

There might be some caching involved, but try filtering based on the search string

Field

Customer

Search String

="=Sum(Volume)>200"