topic Re: Conditional Show in QlikView

Conditional Show

Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Conditional Show

sunny_talwar — Fri, 21 Oct 2016 15:33:54 GMT

Try this as your conditional hide/show expression:

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

Re: Conditional Show

Fri, 21 Oct 2016 15:41:59 GMT

No luck there Still not working

Re: Conditional Show

sunny_talwar — Fri, 21 Oct 2016 16:13:57 GMT

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?

Re: Conditional Show

Anonymous — Fri, 21 Oct 2016 16:44:20 GMT

Try this

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

Re: Conditional Show

MK9885 — Fri, 21 Oct 2016 16:55:38 GMT

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.

Re: Conditional Show

Anonymous — Fri, 21 Oct 2016 17:11:21 GMT

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

Just the condition to be shown.

Re: Conditional Show

Fri, 21 Oct 2016 23:00:53 GMT

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"

Re: Conditional Show

Fri, 21 Oct 2016 23:04:03 GMT

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.

Re: Conditional Show

sunny_talwar — Sat, 22 Oct 2016 14:07:37 GMT

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

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

Re: Conditional Show

rwunderlich — Sat, 22 Oct 2016 14:26:34 GMT

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

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

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Conditional Show

Mon, 24 Oct 2016 07:59:51 GMT

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

Re: Conditional Show

Mon, 24 Oct 2016 08:00:00 GMT

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

Re: Conditional Show

Mon, 24 Oct 2016 08:04:13 GMT

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

Re: Conditional Show

Mon, 24 Oct 2016 08:04:39 GMT

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

Re: Conditional Show

jyothish8807 — Mon, 24 Oct 2016 08:25:00 GMT

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

Re: Conditional Show

jyothish8807 — Mon, 24 Oct 2016 08:53:34 GMT

Hi Bruce,

Pfa sample. Hope this is you are looking for.

Regards

Re: Conditional Show

leni_harishwara — Mon, 24 Oct 2016 10:12:52 GMT

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

Re: Conditional Show

Mon, 24 Oct 2016 10:37:58 GMT

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

Re: Conditional Show

susovan — Mon, 24 Oct 2016 12:25:40 GMT

It might be help

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