# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

New Contributor II

## if...else in formula

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

5 Replies
Honored Contributor III

## Re: if...else in formula

Stefen please explain what you want by this expression

New Contributor II

## Re: if...else in formula

In my formula value2 should have b or c.

Not applicable

## Re: if...else in formula

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

MVP

## Re: if...else in formula

Try something like:

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

Valued Contributor III

## Re: if...else in formula

Hi Stefan

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

now try this

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