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))
