topic Report showing Previous Day in QlikView

Report showing Previous Day

tchovanec — Thu, 27 Feb 2014 13:50:05 GMT

I am trying to create a report that will only show the previous days numbers. Here is what I have tried with no success. I created an On open action and set the date to TODAY()-1. I then created the report and I have the report running after the document reload, but the report is not only showing the day before. It is running for every date. Any ideas on how to get this fixed? Thank you,

Re: Report showing Previous Day

whiteline — Thu, 27 Feb 2014 21:24:12 GMT

Hi.

Have you checked your trigger action expression to work with a button action for example ?

Re: Report showing Previous Day

maxgro — Thu, 27 Feb 2014 21:54:20 GMT

It seems to me the trigger should work

I try with a sheet trigger (select in field + lock field), see attachment

Re: Report showing Previous Day

Thu, 27 Feb 2014 22:12:04 GMT

Thomas,

You can try

1) create a variable v1

= '(' & today()-1 & ')'

2) set your select field action

= '$(v1)'

The select field must be populated with '(field1|field2|.....)' (the quotes belong to the content of the field !!)

Fabrice