Set analysis in if statement

[venkat1]

Hi ,

My stement is like this

if( og.VC_CATEGORY= 'GOLD','GOLD',
if( og.VC_CATEGORY= 'DIAMOND','DIAMOND'))

for the above statement i need to write the set analsis ,where the set value is "og.vc_purity=24"

og.vc_purity =24 should write in og.vc_category='GOLD'.

Please help how to write this .

[felipedl]

Hi, just make a expression like:
sum({<og.vc_purity={24},og.vc_category={"GOLD"}>}Value)

[venkat1]

HI 

if(sum({<og.vc_purity={24},og.VC_CATEGORY= {"GOLD"}>}'GOLD',
if( og.VC_CATEGORY= 'DIAMOND','DIAMOND',
if( og.VC_CATEGORY= 'PLATINUM','PLATINUM')))) 

i tried like that,it was not working 

[Anil_Babu_Samineni]

I think this is what you are expecting?

if(Only{<og.vc_purity ={24}>} og.VC_CATEGORY)= 'GOLD','GOLD',
if(Only({<og.vc_purity ={24}>} og.VC_CATEGORY)= 'DIAMOND','DIAMOND'))

[venkat1]

Hi 

Its not working 

[Anil_Babu_Samineni]

Where you are trying this? What is the expected result.

[venkat1]

i was using in the dimensions for the pivot table.