topic Re: Suggest me the set analysis format for If statement in QlikView

Suggest me the set analysis format for If statement

Anonymous — Fri, 28 Aug 2015 10:52:58 GMT

Hi,

Suggest me the set analysis format for the below If statement

if(only(ActivityFeedTask_Type__c)='Call', 'Call' & ' ( ' & count(ActivityFeedTask_Type__c)& ' ) ',

if(only(ActivityFeedTask_Type__c)='SalesApp activity', 'SalesApp Activity' & ' ( ' & count(ActivityFeedTask_Type__c)& ' ) '

)

For improving the perfomacne i want present this expression with Set Analysis

In-Advance

Thank You

Kushal_Chawda — Fri, 28 Aug 2015 11:19:42 GMT

Are you using ActivityFeedTask_Type__c in Dimesion?

Gysbert_Wassenaar — Fri, 28 Aug 2015 11:20:38 GMT

Set analysis can't do branching, only filtering. That means your nested if statement cannot be translated into a set analysis expression.

jonathandienst — Fri, 28 Aug 2015 11:24:27 GMT

Set analysis is for filtering and selecting data. It is not a universal replacement for if statements.

Kushal_Chawda — Fri, 28 Aug 2015 11:57:01 GMT

Instead of IF you can use, Pick, match with set analysis

pick(match(ActivityFeedTask_Type__c,'Call','SalesApp activity'),

ActivityFeedTask_Type__c&'('&count({<ActivityFeedTask_Type__c={'Call'}>}ActivityFeedTask_Type__c)&')',

ActivityFeedTask_Type__c&'('&count({<ActivityFeedTask_Type__c={'SalesApp activity'}>}ActivityFeedTask_Type__c)&')')

Anonymous — Fri, 28 Aug 2015 12:19:08 GMT

Thank you Exprerts for the Promt response