topic Re: if...else in formula in QlikView

if...else in formula

Anonymous — Fri, 20 Dec 2013 10:04:59 GMT

Hi,

is it's possible to use if...else in formula?

sum ( { <value1= { 'a' }, value2 = { 'b' }>} eur)

sum ( { <value1 = { 'a' }, value2 = { if (value3 = 2,'b','c' } >)

Regards

Stefan

sujeetsingh — Fri, 20 Dec 2013 10:15:14 GMT

Stefen please explain what you want by this expression

Anonymous — Fri, 20 Dec 2013 10:23:23 GMT

In my formula value2 should have b or c.

Fri, 20 Dec 2013 10:31:01 GMT

hi Stefan,

i don't think that if...else can use internal set analisis,

if...else is an alternative the set analisis:

sum(if...)

Regards

tresB — Fri, 20 Dec 2013 10:31:04 GMT

Try something like:

sum ( { <value1 = { 'a' }, value2 = { " $(=if (value3 = 2,'b','c')) "} >} eur)

senpradip007 — Fri, 20 Dec 2013 10:38:04 GMT

Hi Stefan

evaluate if( value3 = 2, 'b', 'c') in a variable let say x.

now try this

Sum({< value1 = {'a'}, value2 = {$(x)} >} eur)