Set analysis with Today()

Wed, 25 Sep 2013 12:53:50 GMT

I have a button with a action that sets a report date to today. If the data has today's data then it will show although if there is no data for today, I was expecting qlikview to hide the data on the page but it doesn't do anything because it can't find today's data in the data set.

On Action tab

Field = Report Date

Search String = Date(Today(), 'DD/MM/YYYY')

Is there any way I can hide all data if no today's data is found.

Thanks

Re: Set analysis with Today()

Wed, 25 Sep 2013 18:27:20 GMT

Hi,

You can search for the max date at after load and put into a variable, and use this variable to Enable / Show Condition.

1st. Step

______________________________________________________________________

// Insert this code bellow the fact table load.

//********************Peek the max date ***************************

tmp:
LOAD
max(date) as max_date

Resident FactTable;

LET VariableMaxDate=peek('max_date',0,'tmp');

Drop Table tmp;

//*************************************** ***************************

2nd. Step

______________________________________________________________________

Put the condition on the object,

topic Set analysis with Today() in QlikView

Set analysis with Today()

Re: Set analysis with Today()