topic Re: Can we restrict today function while opening dashboard in QlikView

Can we restrict today function while opening dashboard

agni_gold — Mon, 02 May 2016 09:00:35 GMT

Hi All ,

Can we do this ,

I have a requirement , i have a variable which is created in scripting , and my chart is using today function for date , now i want that if my variable condition is true then today will today

if condition is false the today will not be today it will be at some other date.

Thanks

Agnivesh

Re: Can we restrict today function while opening dashboard

sunny_talwar — Mon, 02 May 2016 09:02:04 GMT

Can you provide some details on what variable are we talking about. What exactly are you trying to do? Right now, any solution will be just a guess work

UPDATE: I will try to make a guess:

Field:

Date

SearchString

If(ConditionMet = vVarToday, vVarAnotherDate)

Re: Can we restrict today function while opening dashboard

Peter_Cammaert — Mon, 02 May 2016 09:09:37 GMT

Replace all your today() calls in expressions with a $(vToday) expansion, and in the variable overview define vToday as

=IF ($(vSetInScript), today(), $(vOtherdate))

You can replace $(vOtherDate) with whatever value 'some other date' means, or you can set the value for vOtherDate in your script as well.

Best,

Peter

Re: Can we restrict today function while opening dashboard

agni_gold — Mon, 02 May 2016 09:09:38 GMT

I want to restrict today function value one opening based on condition.

Suppose if i open my dashboard tomorrow then it should not show tomorrow date , it is based on some condition.

Re: Can we restrict today function while opening dashboard

sunny_talwar — Mon, 02 May 2016 09:12:23 GMT

Use an if statement in your OnOpen Trigger

Re: Can we restrict today function while opening dashboard

agni_gold — Mon, 02 May 2016 09:19:37 GMT

In on open trigger , if i use any condition , then can it be change today() function value.