topic Re: formula issue in QlikView

formula issue

samuel_brierley — Tue, 21 Jan 2014 08:34:34 GMT

Can anyone see an error in this formula?

sum({$< Date }<= {$(=Today()))>} [Total Hours])

its supposed to sum the total hour worked up until today.

p.s needs to be done this way as i have forecasted hours too.

jagan — Tue, 21 Jan 2014 08:38:23 GMT

Hi,

Try this.

sum({$< Date = {'<=$(=Today())'}>} [Total Hours])

Regards,

Jagan.

Sokkorn — Tue, 21 Jan 2014 08:39:35 GMT

Hi,

This one

Sum({$<Date = {"<=$(=Date(Today(),'dd-MM-yyyy'))"}>} [Total Hours])

Note: You need format Today() base on your Date field.

Regards,

Sokkorn

samuel_brierley — Tue, 21 Jan 2014 08:39:49 GMT

thank you

Tue, 21 Jan 2014 08:40:09 GMT

Hi,

There is a bracket too much after Date.

Moreover, I would write the expression like that (not tested however):

sum({$< Date = {“<= $(=Today()) )”>} [Total Hours])

Fabrice

khadeer — Tue, 21 Jan 2014 08:40:21 GMT

Hi Samuel,

Use this

sum({$<Date={"$(=Today())"}>}[Total Hours])

Regards,

Khadeer