Conditional Show

[#1]

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)

[rwunderlich]

I would use Today(2) -- date document was opened -- as more efficient. So either:

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

or

=NOT InDay(ReloadTime(), Today(2), 0)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#3]

No luck with one I have found One that it works if i go to font> calculated then use the expression however with the text box that displays a warning icon i have no luck

[#4]

No luck with one I have found One that it works if i go to font> calculated then use the expression however with the text box that displays a warning icon i have no luck

[#5]

For the warning Icon I went with =IF(Floor(ReloadTime()) < Today(2), 'qmem://<bundled>/BuiltIn/cross_r.png', '')

[#6 · Accepted solution]

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

[jyothish8807]

Hi Bruce,

What is the frequency of your load ? If it is daily then daily "DD/MM/YYYY' would be enough. If the frequency of the load is more than twice in a day then you will require time stamp to compare both reload time and today().

Regards

KC

[jyothish8807]

Hi Bruce,

Pfa sample. Hope this is you are looking for.

Regards

KC

[leni_harishwara]

Hi,

Instead of converting to Date, convert it to num (used floor and it contains decimal values) and do the comparison it will work as expected,

=IF(Floor(ReloadTime()) = Floor(Today()), 0, 1)

Regards,

Leni

[#10]

Hii

Try this one. It works 100%

=IF(

Floor( num(DATE(ReloadTime(),'DD/MM/YYYY') ) )

=

Floor( num( DATE(Today(),'DD/MM/YYYY')))

,0,1)

Put both conditions in variables if possible and use variable here in comparison.

Thanks in advance.

Regards,

Lalit

[susovan]

It might be help

=if(Floor(ReloadTime())=Floor(Today()),0,1)