topic Re: Show / Hide object based on current date in QlikView

Show / Hide object based on current date

Wed, 16 Apr 2014 15:19:23 GMT

Hi everyone,

I'm creating a timeline like this:-

There is a red image with a text box on top of it. The text box has some set analysis in it so that it always shows only Aprils cost etc irrelevant of any other sheet selections.

I only want to show the red image and text object if the month is in the past. We're still in April so I want the objects to automatically appear at the 1st May and stay there until the new financial year starts. And then I can apply the same logic to the other months.

Can anyone advise me on how to do this?!

Thanks muchly

Natalie

xXx

Re: Show / Hide object based on current date

MK_QSL — Wed, 16 Apr 2014 15:22:44 GMT

your sample apps please !

Re: Show / Hide object based on current date

richard_pearce6 — Wed, 16 Apr 2014 15:27:58 GMT

Hi,

You can use the Conditional Show option in the Layout Menu.

Something like

=if ( Today() > '01-May-2014' and Today() < '6-Apr-2015', 1,0) =1

Richard

QlikCentral.com

Re: Show / Hide object based on current date

Wed, 16 Apr 2014 15:34:50 GMT

Thank you muchly!

xXx

Re: Show / Hide object based on current date

Wed, 16 Apr 2014 15:35:33 GMT

Sorry what do you mean ???