topic Set analysis together with an if statement in QlikView

Set analysis together with an if statement

Sat, 24 Jan 2015 13:37:48 GMT

Goodday,

I'm new here and this is the first time i ask a question on a forum

Can somebody help me with the next formule?

The formule is wrong

sum({$<[winkel naam]={Maasstraat}>}if(sum([transactie bedrag])>0, sum([transactiebedrag kostprijs])))

-if(sum([transactie bedrag])>0, sum([transactiebedrag kostprijs]))*1.01

this part of te fomule is working correctly

sum({$<[winkel naam]={Maasstraat}>}

this part is also working correctly

Together it is not working

Thanks in advance

the Bakermen

Anonymous — Sat, 24 Jan 2015 13:47:38 GMT

Hi,

Try:

sum({$<[winkel naam]={Maasstraat},[transactie bedrag}= {'>0'} >},[transactiebedrag kostprijs]))

Sat, 24 Jan 2015 13:57:07 GMT

Hi,

Thanks for the fast reaction.

Sorry it is not working it is red underlined from this part: [transactie

bedrag}= {'>0'} >},[transactiebedrag kostprijs]))

neetha P schreef op 24-1-2015 om 14:47:

Qlik Community

anbu1984 — Sat, 24 Jan 2015 14:04:07 GMT

Add quotes around string 'Maasstraat' and replace } by ]

=sum({$<[winkel naam]={'Maasstraat'},[transactie bedrag]= {'>0'} >}[transactiebedrag kostprijs]))

francoiscave — Sat, 24 Jan 2015 14:12:39 GMT

Hi Remko,

See th document below to play with Set analysis :

Document posted by Geeta Alhan

Have fun with QV,

François

Wed, 04 Feb 2015 12:16:02 GMT

if(sum([transactie bedrag])>0, sum({$<[winkel naam] = {Maasstraat} >} [transactiebedrag kostprijs]))

Found the solution