Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try:
sum({$<[winkel naam]={Maasstraat},[transactie bedrag}= {'>0'} >},[transactiebedrag kostprijs]))
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
>
Add quotes around string 'Maasstraat' and replace } by ]
=sum({$<[winkel naam]={'Maasstraat'},[transactie bedrag]= {'>0'} >}[transactiebedrag kostprijs]))
Hi Remko,
See th document below to play with Set analysis :
Document posted by Geeta Alhan
Have fun with QV,
François
if(sum([transactie bedrag])>0, sum({$<[winkel naam] = {Maasstraat} >} [transactiebedrag kostprijs]))
Found the solution