Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Performance Improvement

Hi Everyone,

 I have a question regarding the performance.My code is like 

Load A as A

B as B 

Resident table where x=1 

Concentate

Load A as A1

B as B1

Resident table where x=2

Code is working fine but I am not sure whether it impacts the performance.Let me know if there is any better way to achieve this

 

1 Solution

Accepted Solutions
Specialist
Specialist

You can check the following in order to see which is more quick:

 

Load

if(Match(x,1),A)  as A,

if(Match(x,1),B)  as B,

if(Match(x,2),A)  as A1,

if(Match(x,2),B)  as B1

Resident table where Match(x,1,2) 

To help community find solutions, please don't forget to mark as correct.

View solution in original post

1 Reply
Specialist
Specialist

You can check the following in order to see which is more quick:

 

Load

if(Match(x,1),A)  as A,

if(Match(x,1),B)  as B,

if(Match(x,2),A)  as A1,

if(Match(x,2),B)  as B1

Resident table where Match(x,1,2) 

To help community find solutions, please don't forget to mark as correct.

View solution in original post