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

Conditional Show

Dear All,

I have a text box that I want to show based on a condition but it is not working. Am i missing something???

IF(DATE(ReloadTime(), 'DD/MM/YYYY') = DATE(Today(), 'DD/MM/YYYY'), 0, 1)

1 Solution

Accepted Solutions
Not applicable
Author

For the warning icon i used =IF(Floor(ReloadTime()) < Today(2), 'qmem://<bundled>/BuiltIn/cross_r.png', '') and it works

View solution in original post

19 Replies
sunny_talwar

Try this as your conditional hide/show expression:

=Floor(ReloadTime()) = Floor(Today(1))

Not applicable
Author

No luck there Still not working

sunny_talwar

Have you checked in a text box object the value of the two things

=ReloadTime()

=Today()

are they both showing today's date or not?

Anonymous
Not applicable
Author

Try this

= DATE(ReloadTime(), 'DD/MM/YYYY') = DATE(Today(), 'DD/MM/YYYY')

MK9885
Master II
Master II

Refreshtime:

load

QvdCreateTime('$(vQVD_E_Directory)\YOURFACTTABLE.QVD') AS QVDTIME

AutoGenerate 1;

You can use above script to generate a field for your QVD refresh time. If that's what your goal is?

Then use this field in front end.

Anonymous
Not applicable
Author

Layout / Show / Conditional not need to use the "If".

Just the condition to be shown.

Not applicable
Author

The goal is to show text in a text box informing the user that the reload failed hence the conditional show. if the reload is successful nothing will be shown the text box will be hidden. the text box has red font on the dashboard which says, " Reload failed please contact XXXX"

Not applicable
Author

Hi yes the dates are showing fine however The goal is to show text in a text box informing the user that the reload failed hence the conditional show. if the reload is successful nothing will be shown the text box will be hidden. the text box has red font on the dashboard which says, " Reload failed please contact XXXX"

The textbox will be hidden if Reloadtime() = Today()

The Textbox will show if reload time() is less than today. e.g. yesterday.

sunny_talwar

If they are the same and they need to be hidden, then you need this condition

=Floor(ReloadTime()) <> Floor(Today(1))