Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Application performance issue when multiple getselected count condition is used in expression

Hi All,

I am facing trouble in few of the tables of my Qliksense app. I have a requirement of displaying latest date data by default and and wen year/month/week/date of multiple day selection is made it should sum up the value. I am using straight table for this. I have achieved this using multiple getselected count condition in expressions of my table, but the performance was taking hit as i had many columns and rows which used to take lot of time to aggregate the condition. So i tried everythng in script level and just pulled the column and gave the get selected count condition. This worked for one of the app, but facing the same issue now for other app evn aftr trying evrythng in script level. 

Can anybody help me out here to sort this out.

Here is my code

scripting part:

Rep:
LOAD
date,
id as rep_id,
classification as rep_classification,
PurgeChar(further_classification,'"') as rep_further_classification,
id_owner as rep_id_owner,
flag as rep_flag,
tag as rep_tag,
e_flag as rep_e_flag,
sum(qty) as rep_qty,
sum(value) as rep_value,
sum(s_qty) as rep_s_qty,
sum(r) as rep_r,
sum(e_qty) as rep_e_qty,
sum(e_value) as rep_e_value,
if(e_flag = 'NA',sum(e_d)) as rep_e_d,
((sum(s_qty) + sum(qty)) / sum(r)) as I_D,
(sum(e_qty) / sum(r)) as A_D

group by
date,
id,
classification,
further_classification,
id_owner,
flag,
tag,
e_flag;

Expression:

if(GetSelectedCount(date)>1 or GetSelectedCount(Week)>0 or GetSelectedCount(Month)>0,
sum({<DateID ={"<=$(=max(DateID))>=$(=min(DateID))"}>}rep_qty),

sum({<DateID ={"$(=max(DateID))"}>}rep_qty))

0 Replies