Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help!! Can any one suggest alternative to 'if' statement?

Hi...

Can any one suggest alternative to 'if' statement. so that my performance of my dash board increases. i was told it because of 'if' statement my dash board performance is not good.

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

Check this

Regards

ASHFAQ

View solution in original post

4 Replies
aveeeeeee7en
Specialist III
Specialist III

Hi

You have 2 options:

1) Create if statement in the backend Script and than use that field in your Charts Dashboard.

2) Use Set Analysis. It is performance wise faster.

Regards

Av7eN

Not applicable
Author

I guess i cant use IF statement in the back end script as it might expose functionality to user. i need to publish my dashboard on EG server.

I can try out Set Analysis. Can you please provide a compassion code for IF and SET analysis.

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this

Regards

ASHFAQ

aveeeeeee7en
Specialist III
Specialist III

eg.

IF STATEMENT:

Count(Distinct if(Product='Butter' or Product='Milk',Tokens)

SET ANALYSIS:

In Set Analysis you can write Multiple Statements.........

=count({<FLAG={'OPEN'},Status-={'Not Delivered'},[Common Date]={">=$(=Date(vminDate),'DD/MM/YYYY'))<=$(=Date(vMaxDate1,'DD/MM/YYYY'))"},[Common Month]=,[Common Year]=>}DISTINCT Token)

Regards

Av7eN