topic Re: Message Box in QlikView

Message Box

Anonymous — Fri, 08 Jul 2016 19:04:20 GMT

I have a requirement to display alert message, sometimes the data build fails which result in dashboard displaying old data , so I want a message box to display stating that the data is not latest.

The data updates every Friday , so I will have to check if the data is latest Friday, so I have created a text box with the condition in Layout tab as below :

if(Date(Floor(WeekEnd(Today()) - 9)) = max(date(Date)),0,1)

But I have a filter to select the Date values in the Dashboard which by default is set to show latest Friday date , when the user manually selects a date other than the latest date , the message box is appearing , which i want to avoid . How can i achieve this?

Thanks

Re: Message Box

boorgura — Fri, 08 Jul 2016 19:10:15 GMT

Please try using this:

if(Date(Floor(WeekEnd(Today()) - 9)) = max({1} date(Date)),0,1)

Re: Message Box

sunny_talwar — Fri, 08 Jul 2016 19:10:58 GMT

Try this:

If(WeekEnd(Today()) - 9 = Max({1}Date), 0, 1)

Update: No need to add the extra functions which don't add any value

Re: Message Box

alexpanjhc — Fri, 08 Jul 2016 20:06:16 GMT

there is a function called reloadtime()

Maybe you can show that as a box so people know when this is reloaded last?

Re: Message Box

johnw — Fri, 08 Jul 2016 20:16:27 GMT

Floor() adds value because weekend() returns a timestamp of the last millisecond of the week, which will never equal a date value.

Re: Message Box

johnw — Fri, 08 Jul 2016 20:17:08 GMT

Rather than a text box, you could use an actual alert. The condition can probably be the same, use "On Open" as the event, and put in the message you want displayed. You don't need the {1} then, because the only time it will check the condition is when the app is first opened.

Re: Message Box

sunny_talwar — Fri, 08 Jul 2016 20:47:44 GMT

That's true, thanks for catching that John

Re: Message Box

Anonymous — Mon, 11 Jul 2016 19:11:26 GMT

Please find the attached app .. I used same .. still my text object remains ..instead of disappearing !

TX369 - text object id

Re: Message Box

johnw — Mon, 11 Jul 2016 19:17:18 GMT

You might need to use <> instead of =.

Re: Message Box

Anonymous — Mon, 11 Jul 2016 19:30:28 GMT

This message to alert that the data is not updated , so when max date is equal to Friday's date then I don't want this message to appear , when it is not equal to then I want this message to appear as the data is not updated. Hope it makes sense

Re: Message Box

johnw — Mon, 11 Jul 2016 20:41:08 GMT

How about this as the conditional show expression?

floor(weekend(today())-9) <> max({1} Date)

Re: Message Box

Anonymous — Fri, 22 Jul 2016 18:46:21 GMT

This actually failed today , as today being a Friday (Data updated every Friday, so max dates will be Friday's dates only).. the msg box appeared even though the data was updated

floor(weekend(today())-9) gives me 7/15/2016 , and max date is 7/22/2016 , I should be checking current Friday's date and if current Friday's date is not equal to Max date then the msg box should appear , can you please let me know how I can check for current Friday's date as well?

May be like below , but the below is not working

(date(floor(weekend(today())-9)) <> max({1} Date) or
date(floor(weekend(today())-2)) <> max({1} Date))

Thanks

Re: Message Box

johnw — Fri, 22 Jul 2016 19:03:40 GMT

What do you mean by "the current Friday?" What date do you want returned for each of these dates?

Mon July 11, 2016 --> ?
Tue July 12, 2016 --> ?
Wed July 13, 2016 --> ?
Thu July 14, 2016 --> ?
Fri July 15, 2016 --> ?
Sat July 16, 2016 --> ?
Sun July 17, 2016 --> ?

Re: Message Box

johnw — Fri, 22 Jul 2016 19:08:08 GMT

The expression...

(date(floor(weekend(today())-9)) <> max({1} Date) or
date(floor(weekend(today())-2)) <> max({1} Date))

...is always true. It's of this form:

A-9<>X or A-2<>X

If A-9=X, then A-2 cannot = X.

If A-2=X, then A-9 cannot = X.

So the expression is always true.

It might be more obvious if you write the negation of the expression:

not(A-9<>X or A-2<>X)

which is equivalent to this

A-9=X and A-2=X

It should be obvious that this cannot ever be true. Therefore its opposite is always true.

Re: Message Box

Anonymous — Fri, 22 Jul 2016 19:19:30 GMT

This particular tab reloads data every Friday , so the Max Date is always a Friday's date , so I need check if the current Friday's Date is equal to Max Date , so today the application reloaded and the Max Date is 7/22/2016 , and current Friday date is 7/22/2016 , and on Monday the I still have to check with previous Friday Date which is 7/22/2016 , because the Data updates next only on 7/29/2016 .. until then date that I have to check is 7/22/2016 only.

The application reloads every day 3 times , but the data for this particular tab reloads only weekly.

so below is what I want

Mon July 11, 2016 --> 7/8/2016
Tue July 12, 2016 --> 7/8/2016
Wed July 13, 2016 --> 7/8/2016
Thu July 14, 2016 --> 7/8/2016
Fri July 15, 2016 --> 7/15/2016
Sat July 16, 2016 --> 7/15/2016
Sun July 17, 2016 --> 7/15/2016

Hope it makes sense!

Re: Message Box

johnw — Fri, 22 Jul 2016 19:26:17 GMT

It does make sense, thank you. This should get you those dates:

weekstart(today(),0,4)