topic Add value out QV table in textbox in QlikView

Add value out QV table in textbox

Tue, 24 May 2011 09:45:23 GMT

Hello all, in my QV application I have a table where I store a date for the most recent data of the different sources, this looks like this

I also store a variable with the the last scriptload date, now i want a text box with the last loaded date en the most recent date (depending on the selected source, always only one selected!)

Now i have the following code;

='Last data load: '&$(vLastScriptLoad)&chr(10)&'Most recent data: '

Now I want a function te get the right value out of the table. I would say the peek functio but that one isn't available in a text box.

Can anyone help me out here, Thnx in advance!

Add value out QV table in textbox

kaushiknsolanki — Tue, 24 May 2011 10:10:59 GMT

Hi,

What you want to show after the Most Recent Data.

If it is the date. Meaning is a user selects Source and you want to show the corresponding Date, then the statement will be

='Last data load: '&$(vLastScriptLoad)&chr(10)&'Most recent data:' & Date

Regards,

Kaushik Solanki

Add value out QV table in textbox

Tue, 24 May 2011 10:13:01 GMT

Hi,

You can try Max(Date)

Add value out QV table in textbox

Tue, 24 May 2011 10:15:52 GMT

Hi,

what you can do is this

Temp_CalendarRange:
Load Max(Datefield) as [vMaxDate]
Resident Table;

LET vMaxDate = Peek('vMaxDate', 0, 'Temp_CalendarRange');
Now use this variable in the text box like this
='Last data load: '&$(vLastScriptLoad)&chr(10)&'Most recent data: '$(VMaxDate)

Hope that helps

sravan

Add value out QV table in textbox

Tue, 24 May 2011 10:54:21 GMT

Thnx!! Didn't expect it to be that simple!