Convert IF condition into set analysis.

savitakhyadi — Sat, 06 Oct 2018 14:16:51 GMT

Hi Everyone,

I am facing a lot of performance issues in my dashboard. I figured it out its because of IF conditions which I am using in the variables.

I am trying to convert these into set analysis but not able to do.

Below are the 2 different expressions which i want to convert into set analysis.

If(v_Summary_KPI='PN',

if(sum(aggr(sum(aggr(max({$<Flag={'Opportunity_Snapshot'},[Snapshot Quarter]={'Q1'},[GBU]={'Advisory and Professional Services','Operational Services'},[Fiscal Quarter]=,[Fiscal Month]=,[Activity Status]={'Completed'},[Presales Sub Type]={'Solution Development'},[Solution WorkEffort TAT Adjusted]-={}>}[Solution WorkEffort TAT Adjusted]),[Activity ID],[HPE Opportunity Id])),[HPE Opportunity Id]))

/Count({$<Flag={'Opportunity_Snapshot'},[Snapshot Quarter]={'Q1'},[GBU]={'Advisory and Professional Services','Operational Services'},[Fiscal Quarter]=,[Fiscal Month]=,[Activity Status]={'Completed'},[Presales Sub Type]={'Solution Development'},[Solution WorkEffort TAT Adjusted]-={}>} DISTINCT [Activity ID])<=10,

num(sum(aggr(sum(aggr(max({$<Flag={'Opportunity_Snapshot'},[Snapshot Quarter]={'Q1'},[GBU]={'Advisory and Professional Services','Operational Services'},[Fiscal Quarter]=,[Fiscal Month]=,[Activity Status]={'Completed'},[Presales Sub Type]={'Solution Development'},[Solution WorkEffort TAT Adjusted]-={}>}[Solution WorkEffort TAT Adjusted]),[Activity ID],[HPE Opportunity Id])),[HPE Opportunity Id]))

))

---> This expression I use to calculate all four qtrs,its just I change qtr num here like q1,q2,q3,q4.

--------------------------------------------------------------------------------------

2) This is 2nd expression where I compare q1,q2 data and show the arrows based on value increase/decrease.

If(if(isnull(vSolWorkEffortQ2),0,vSolWorkEffortQ2)>if(isnull(vSolWorkEffortQ1),0,vSolWorkEffortQ1) ,'qmem://<bundled>/BuiltIn/arrow_n.png',

If(if(isnull(vSolWorkEffortQ2),0,vSolWorkEffortQ2)<if(isnull(vSolWorkEffortQ1),0,vSolWorkEffortQ1) ,'qmem://<bundled>/BuiltIn/arrow_s.png',

If(if(isnull(vSolWorkEffortQ2),0,vSolWorkEffortQ2)=if(isnull(vSolWorkEffortQ1),0,vSolWorkEffortQ1) , 'qmem://<bundled>/BuiltIn/arrow_e.png',

If(if(isnull(vSolWorkEffortQ2),0),' ',

IF(isnull(vSolWorkEffortQ2) , 'qmem://<bundled>/BuiltIn/led.png')))))

but these 2 causing big time slowness to my dashboard.

Can some one please help me to over come this issue.

Many Thanks

topic Convert IF condition into set analysis. in QlikView

Convert IF condition into set analysis.