Solved: IF sentence give me strange results. WHY? - Qlik Community

Report Inappropriate Content · ‎2013-05-09

Hi people!

Pls consider this table:

Why does this expression give me two different results? I expected (20941,92+199) as total?

Best regards

Trond E

fabio_vallone · ‎2013-05-09

=sum({$<[Project Type No.] = {'100', '200'}>} [Allocated Hours])

Anonymous · ‎2013-05-09

Trond Erik

Could you please upload a sample qwv file? It will be much easier to figure out what's wrong?

Regards

MutliView

Report Inappropriate Content · ‎2013-05-09

try if(<conditions>, sum(Allocated_Hours) )

fabio_vallone · ‎2013-05-09

=sum({$<[Project Type No.] = {'100', '200'}>} [Allocated Hours])

Report Inappropriate Content · ‎2013-05-09

Hmmm... but Why?

Thank you very mych!

Best regards
Trond E

fabio_vallone · ‎2013-05-09

why... i really don't know... all I know is set analysis work best within expressions.

hugs

Report Inappropriate Content · ‎2013-05-09

I wonder if we have write an If condition in sum

sum([{set_expression}][distinct][total[<fld {, fld}>]] expression)