topic Re: Set analysis to IF statement in QlikView

Set analysis to IF statement

Anonymous — Thu, 25 May 2017 15:28:17 GMT

Hi QlikView experts,

I am having and issue converting set analysis to IF statement.

I have converted the following:

sum({[DataSet1]<RiskType = {"CountControls"}>}RiskCount)

sum( {[DataSet1]} if(mixmatch( RiskType ,'CountControls')>0,RiskCount))

and it works.

I want to having trouble converting

sum({[DataSet1]<RiskType = >}CountROMM)

to an IF statement. Please help.

Re: Set analysis to IF statement

Anil_Babu_Samineni — Thu, 25 May 2017 15:45:33 GMT

What are you trying to achieve and which statement you want to move in IF condition. Can you explain little more

Re: Set analysis to IF statement

Anonymous — Thu, 25 May 2017 15:52:34 GMT

The data model I am using is inefficient. Showing high Calculation Time when using Set Analysis functions. When converted to IF statements, the Calculation Time is decreased a lot and app runs faster. This is a short term solution while I work on fixing the data model.

I want to convert --> sum({[DataSet1]<RiskType = >}CountROMM) to an IF statement. It uses the alternate State DataSet1

Re: Set analysis to IF statement

Anil_Babu_Samineni — Thu, 25 May 2017 16:06:46 GMT

Here, DataSet1 is nothing But Alternate States?

Re: Set analysis to IF statement

Anonymous — Thu, 25 May 2017 16:25:24 GMT

yes, in my app, there is DataSet1 and DataSet2 for comparison

Re: Set analysis to IF statement

Anil_Babu_Samineni — Thu, 25 May 2017 16:37:02 GMT

I wonder is there any option with Alternate states. I don't think so whether we can achieve same In qlik.

Let's wait stalwar1‌ response and feedback on this

Re: Set analysis to IF statement

sunny_talwar — Thu, 25 May 2017 16:40:03 GMT

Looking to ignore selection in a field using if statement? Not possible.... and if giving better performance then set analysis... really? May be try this

Sum({[DataSet1]<RiskType = $::RiskType>} CountROMM)