Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
m_woolf
Master II
Master II

MonthStart()

Roop
Specialist
Specialist

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

Hope it helps

Not applicable
Author

Hi Rupert,

Thank you for responding.

Neither seem to yield a results in my text object.

Regards,

Myles

Peter_Cammaert
Partner - Champion III
Partner - Champion III

...MonthStart(WeekEnd)... ?

Anonymous
Not applicable
Author

The WeekEnd function needs a parameter.

     WeekEnd(Today())

will return the end of today's week.

Not applicable
Author

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