Instead of IF condition

[geogou1973]

Hello,

I have the following expression in Add Calculated Dimension

=if(CAPRAR='ST' or CAPRAR='SZ',STICKER,ITEM_ID)

how can i replace this command with another that not contains if command ?

I have problem with performance when i use the command if

Thank you in advance.

[sunny_talwar]

May be use set analysis instead of calculated dimension

Sum({<ITEM_ID = P({<CAPRAR = {'ST', 'SZ'}>})>}Measure)

[geogou1973]

Hello Sunny,

I have no measures, i use this expression in calculated dimension in order to display

the sticker or the item_id

[sunny_talwar]

Is this not in a chart? Can you elaborate on how you are using this? May be share a sample?

[geogou1973]

Yes this is in a chart in calculated dimension and in expression i have the command sum(sales)

[aarkay29]

Try this,

pick(Match([CAPRAR],'ST','SZ'),[ITEM_ID])

and Supress when value is null

[#7]

You can't completely replace If condition instead you can use:

=if(Match(CAPRAR,'ST','SZ')>0,STICKER,ITEM_ID)

[sunny_talwar]

So try this, I guess

Sum({<ITEM_ID = P({<CAPRAR = {'ST', 'SZ'}>})>} sales)

[geogou1973]

I lose the STICKER, i want if the match is true to display STICKER else to display ITEM_ID

[Peter_Cammaert]

You could create a new field in your data model that contains a different field value depending on the value of CAPRAR. Then it simply becomes a matter of adding this new field as a dimension. The fit depends on the complexity of your data model.

Or you can leave the Calculated Dimension as-is and tackle the performance problems by adding a Calculation condition to empty the object as long as the number of rows is larger than an acceptable maximum. I guess no end user is eager to wade through straight tables containing 10000+ records.