topic Re: Alert_Issue in QlikView

Alert_Issue

Fri, 06 Jun 2014 12:20:08 GMT

I have created a alert message which will display the information of data updated date

for this i use this expression:

='Data as on ' & max(date)

But the problem is, if a user for example select 2014 and Apr and save and close the application

Next time once he/she open the app it will display the max date of previously selected and save month & year

(i.e max date on Apr 2014 rather than Jun 2014)

Is there is any other way ,so that whenever the user open the app it will always display max date instead of selection inn the field

Re: Alert_Issue

Fri, 06 Jun 2014 12:47:26 GMT

why don't you use month(today() & year(today())

best regards

Chris

Re: Alert_Issue

Sat, 07 Jun 2014 05:01:36 GMT

Actually the sometimes data not updated daily most of the times it display the data of Day-1 or Day-2

Re: Alert_Issue

PrashantSangle — Sat, 07 Jun 2014 09:46:25 GMT

Hi,

Try triggers,

Go to Sheet Property->Triggers->OnActivateSheet->Add Actions->Add->Action Type(Selection)->Select in Field->Ok.

Then in Field column ->write field name.

Search Field->write field which you want to select on open.

In your case it should be max(date)

Regards,

Re: Alert_Issue

nagaiank — Sat, 07 Jun 2014 12:11:37 GMT

Try the following expression:

='Data as on ' & max({1} date)

Re: Alert_Issue

Mon, 09 Jun 2014 05:59:13 GMT

No it will not work

Let take an example in one of my dashboard data is updated till 30-apr-2014 .But once i manually reload it, its reload time and max({1}date) will give the same output as 09-06-14

Similar in other dashboard date updated sometimes as day-1 or day 2 or on daily basis

If i use max (date) ..it will result in a problem that once as user open the app and select feb-2013 and save as close the app ,next time when the user open that application ,it will give max date of feb month i.e 18 feb

that is wrong,it should display 09-06-14

Re: Alert_Issue

Tue, 10 Jun 2014 05:09:44 GMT

I resolved the issue and the solution is

go to Document property-Trigger- Document open trigger - On open -Add Action- Max(Year) or MaxString(Year) (i.e. based on your data)

add one more trigger- clear other field and write field name as Year

Apply same logic for month and create a trigger for month as well

Now it will work fine