topic Re: (HELP) Using functions and formula's in an Text Object in QlikView

(HELP) Using functions and formula's in an Text Object

Fri, 27 Mar 2015 14:41:58 GMT

Hello all,

I have a text object where I use function and formula to create a more dynamic title.

I've figure out how to get my desired result for Week of, but now I have another area I would like to fill in that would create an if/or situation. This is if I have selected instead of WeekEnd, MonthEnd.

My formula now is

='>> '&UPPER(Business Unit)&' CYCLE TIME - WEEK OF '&date(WeekEnd-6)&' - '&WeekEnd

Result: Business Unit Cycle Time - Week of 3/16/2015 - 3/22/2015

This formula would then be effected by a multi box I have set up for the Business Unit and WeekEnd variables

Other than the if/or situation I'm not sure how I would be able to account for the starting date of the month like I do above with "-6".

I thank you for any advice you can lend me.

Best Regards,

Myles Holland

Re: (HELP) Using functions and formula's in an Text Object

m_woolf — Fri, 27 Mar 2015 14:49:43 GMT

MonthStart()

Re: (HELP) Using functions and formula's in an Text Object

Roop — Fri, 27 Mar 2015 16:07:28 GMT

You should be able to use WeekStart() and WeekEnd() as well as MonthStart() and MonthEnd()

Hope it helps

Re: (HELP) Using functions and formula's in an Text Object

Fri, 27 Mar 2015 16:30:44 GMT

Hi Rupert,

Thank you for responding.

Neither seem to yield a results in my text object.

Regards,

Myles

Re: (HELP) Using functions and formula's in an Text Object

Peter_Cammaert — Fri, 27 Mar 2015 16:34:40 GMT

...MonthStart(WeekEnd)... ?

Re: (HELP) Using functions and formula's in an Text Object

Anonymous — Fri, 27 Mar 2015 16:35:54 GMT

The WeekEnd function needs a parameter.

WeekEnd(Today())

will return the end of today's week.

Re: (HELP) Using functions and formula's in an Text Object

Fri, 27 Mar 2015 16:47:11 GMT

Hello Bill,

There should already be a parameter.

To restate from my original post I have multibox set up. This multibox has the Business Unit, Week End and now Month End.

='>> '&UPPER(Business Unit)&' CYCLE TIME - WEEK OF '&date(WeekEnd-6)&' - '&WeekEnd works, and shows the result of : Business Unit Cycle Time - Week of 3/16/2015 - 3/22/2015.

However, I need to come up with something more dynamic that tells me the Month Ending instead.

Regards,

Myles Holland