Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

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

6 Replies
mwoolf
Honored Contributor II

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

MonthStart()

rupe
Valued Contributor

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

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

Hope it helps

Not applicable

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

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

...MonthStart(WeekEnd)... ?

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

The WeekEnd function needs a parameter.

     WeekEnd(Today())

will return the end of today's week.

Not applicable

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

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



Community Browser