Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
diwaskarki
Creator II
Creator II

max date

I have a multi box that has a field that display date. How do I bring in only the latest data for a row?

I tried doing that in the script itself but it was bringing in the data weird. I heard you can do that in the multi box itself. I would really appreciate the help. Thanks

3 Replies
Anil_Babu_Samineni

In fact, Multibox won't have much expression level data. So, You can't not sure who gave you doing this within Multibox. Can you explain the scenario exactly what are you going to have?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
devarasu07
Master II
Master II

Hi,

Correct me if i'm wrong. u wanted to display max date by default in your multi-box/list-box object right? if so then try to do below steps,

Go to settings -->Doc. Properties -->Doc. event trigger select as "On Open" and add your date file like below screen short.

maxDate.JPG

diwaskarki
Creator II
Creator II
Author

Hello Stefan,

I finally came up with a script that does it:

date(date#(if(not isnull(Completed_Date),mid(Completed_Date,6,index(Completed_Date,' ',3)-6)&' '&right(Completed_Date,4)),'MMM DD YYYY'),'MM/DD/YYYY') as Access_Date,

I have an extract script that brings data from my database and creates qvd tables. I have created a dashboard which has its own extract script. Data is brought in from the qvd tables and are presented in the dashboard.

The above script is in my extract script to create qvd tables.

I have a script that creates a table called spt_audit_event where  I bring in the "Access_Date" field. I am trying to use the max function in the same script,but it gives me a script error.

However when I create another table doing a resident load from "spt_audit_event" table , the max function works.

The script looks like this:

SPT_AUDIT_EVENT2:
LOAD
Date(Max(Access_Date)) As Access_Date
RESIDENT SPT_AUDIT_EVENT;

But the problem I have is "SPT_AUDIT_EVENT" table is correlated with another table "inactive_autofire_users_report" . I am having trouble correlating this table with spt_audit_event2. Is there a way I can use the max function in the same script where I am bringing the extract date?

I know this sounds very confusing. I cant figure out how to insert a file . I was wanting to upload my script file. Hopefully I am making some sense for you to figure out what I need.

I really appreciate all your help