topic Re: Set analysis in if statement in QlikView

Set analysis in if statement

venkat1 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 29 Apr 2019 12:18:32 GMT

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

venkat1 — Mon, 29 Apr 2019 12:28:57 GMT

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 — Mon, 29 Apr 2019 12:32:53 GMT

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 — Mon, 29 Apr 2019 12:46:50 GMT

Its not working

Anil_Babu_Samineni — Mon, 29 Apr 2019 12:48:25 GMT

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

venkat1 — Thu, 02 May 2019 06:44:06 GMT

i was using in the dimensions for the pivot table.