topic Re: If else condition for below business condition in QlikView

If else condition for below business condition

Anonymous — Mon, 09 Jul 2018 06:14:48 GMT

I have a business requirement in which

If primaryobjective ='Profitability' then it has to through 'Revenue' & 'Pipeline'.

So how to achieve this by If else condition

Thanks

Surya J

dapostolopoylos — Mon, 09 Jul 2018 06:28:14 GMT

If i got it right you need something like that:

if(condition1='Revenue',

if(condition2='Pipeline','Profitability','Other'),

'Other')

Anonymous — Mon, 09 Jul 2018 07:16:06 GMT

Hi Dimi

Tanq for your response

I am trying to achieve the below

=if(primaryobjective ='Profitability','Revenue',

if(primaryobjective='Profitability','Pipeline',

if(primaryobjective='Revenue','Pipeline',

if(primaryobjective='Revenue','Profitability',

if(primaryobjective='Pipeline','Revenue',

if(primaryobjective='Pipeline','Profitability',

primaryobjective))))))

I have added this condition in filter its providing single option for Profitability ,Revenue & Pipeline also.

But It has to single to many.

Can you please suggest?

dapostolopoylos — Mon, 09 Jul 2018 08:57:04 GMT

Your statement doesn't look right to me...

For what kind of business logic you are double checking each individual value of primaryobjective?

Explain what do you want to achieve and why, in order to have a suggestion i must understand whata are you doing