topic Re: Get a varchar field from table in QlikView

Get a varchar field from table

l_denivelle — Tue, 29 Sep 2015 08:26:18 GMT

I have a table which gives me the last refresh dates of data.

I just want to put in a textbox a text like :

="Last refresh on " & MyVariable

My table looks like that :

I want MyVariable to contain the DATE_VALUE where DATE_MNEMONIC=DATE_EXTRACT_OPTIFORM.

How can I do this ?

Thanks

senpradip007 — Tue, 29 Sep 2015 08:30:49 GMT

Do you want ="Last refresh on " & ReloadTime()

l_denivelle — Tue, 29 Sep 2015 08:48:07 GMT

I need the DATE_VALUE from my Table when DATE_MNEMONIC = "DATE_EXTRACT_OPTIFORM"

Because refresh of my data depending on an extraction from a system.

The data do not depend on the application reload.

SreeniJD — Tue, 29 Sep 2015 08:57:22 GMT

Use set analysis and filter the data as required...

DATE_MNEMONIC = "DATE_EXTRACT_OPTIFORM

HTH,

Sreeni

jonathandienst — Tue, 29 Sep 2015 08:59:49 GMT

=Date(Only({<DATE_MNEMONIC = {'DATE_EXTRACT_OPTIFORM'}>} DATE_VALUE))

=Date(Max({<DATE_MNEMONIC = {'DATE_EXTRACT_OPTIFORM'}>} DATE_VALUE))

jonathandienst — Tue, 29 Sep 2015 09:01:15 GMT

l_denivelle — Tue, 29 Sep 2015 09:09:19 GMT

Thank you, it works.

I didn't know the "only" function !