Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
srikanthsri1
Specialist
Specialist

where to give condition for better performance

i have a condition for given straight tables of around 6k records. it's taking so much time to load.

i have multiple if condition like  eg:

if getselected count(field)=1, sumx,

if getselected count(field)=2, sumy+sumX,

if getselected count(field)=3, sumz+sumy+sumX

so the straight table is loading slow

instead of that i want to give

condition in general i.e calculation condition ,

conditional enabling in expression ,

condition in layout

which is good for better performance....if not is there any good solution to optimize staright table

plz help

Thanks

have a Great day

6 Replies
rajeshvaswani77
Specialist III
Specialist III

See if you can move this condition to your scripting level. That will be the optimum option.

-RV

srikanthsri1
Specialist
Specialist
Author

Thanks Rajesh for your response,

  the expression i'm using is not straight forword, it actualy something like this

= (set exp1/set exp2)/set exp3/set exp4)

so i think that something not possible to bring from scrpiting .

Any other suggestions will be much appricated

shree909
Partner
Partner

why dont u create variables for differnt  variables

if getselected count(field)=1, sumx,  as variable 1

if getselected count(field)=2, sumy+sumX,as variable 2

if getselected count(field)=3, sumz+sumy+sumX  as variable 3

and then use an if condition .. that may help u

srikanthsri1
Specialist
Specialist
Author

Thanks For the reply Shree,

what i'm thinking is   3 object with each condition in layout like getselected count(field)=1

getselected count(field)=2, for another object

getselected count(field)=3, for another object

and give direct expression in expresion tab..

in the above case calculation happens only once ie. get secleted calculation and followed by sum

as you said , if i  give them in variable , for each values of dimension it should calculates the variable + if condition

for the variables...so I feel  it takes more calculation time .correct me if i'm wrong 😮

Thanks once again

CELAMBARASAN

Hi,

This might work for you i think.Check it

Pick(getselected count(field),sumx,sumy+sumX, sumz+sumy+sumX);

Hope this helps

srikanthsri1
Specialist
Specialist
Author

Thanks for the reply Celambarasan, it helps me

and let me add something to it

I have condition like

get slected count(field1)>0,exp1

get slected count(field2)>0,exp2

get slected count(field1) and  get slected count(field2)>0,exp3

in this case which option is better i'm thinking of going to have 3 objects with each diff condition in layout