topic Re: Formula not working in QlikView

Formula not working

danialier — Fri, 21 Feb 2014 13:48:49 GMT

Hello,

Any idea why this formula is not working ?

=num(sum({<[Product Line]={'Hardware'},Measure={'CI'},Category={'Lseries'},Month#=max(Month#)>}Units),'#,##0')

thks,dani

MK_QSL — Fri, 21 Feb 2014 13:50:27 GMT

=num(sum({<[Product Line]={'Hardware'},Measure={'CI'},Category={'Lseries'},Month#= {‘$(= max(Month#))’}>}Units),'#,##0')

Colin-Albert — Fri, 21 Feb 2014 13:52:06 GMT

Can you test that max(Month#) returns a valid value?

Is the case of 'Lseries' correct? Could it be 'LSeries' perhaps?

Fri, 21 Feb 2014 13:53:30 GMT

=num(sum({<[Product Line]={'Hardware'},Measure={'CI'},Category={'Lseries'},Month#={'$(=max(Month#))'}>}Units),'#,##0')

danialier — Fri, 21 Feb 2014 13:55:45 GMT

cool !