Set analysis to IF statement

[Anonymous]

Hi QlikView experts,

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

I have converted the following:

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

to

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.

[Anil_Babu_Samineni]

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

[Anonymous]

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

[Anil_Babu_Samineni]

Here, DataSet1 is nothing But Alternate States?

[Anonymous]

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

[Anil_Babu_Samineni]

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

[sunny_talwar]

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)