Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Can we restrict today function while opening dashboard

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

5 Replies
sunny_talwar

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)

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

agni_gold
Specialist III
Specialist III
Author

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.

sunny_talwar

Use an if statement in your OnOpen Trigger

agni_gold
Specialist III
Specialist III
Author

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