Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stefan_fischer
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
sujeetsingh
Honored Contributor III

Re: if...else in formula

Stefen please explain what you want by this expression

stefan_fischer
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
MVP

Re: if...else in formula

Try something like:

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

senpradip007
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)

Community Browser