No display of today

[#1]

Hi

I have a small problem. Using QV 10,0. I would like to not show today (but every day in the month before today) when opening a report. I know that I can make a trigger when opening the report. And I have already a trigger on month ( = month(today()) ).

I have tried to use the following in a new trigger on day:

=day (before(today()))

=day (not(today()))

=day (<today())

=day (today()-1)

But non of these is giving me a correct result.

If I use = day (today()) then it will show today, but how do I exclude today?

[#2]

Have you considered putting an advanced search in a bookmark (such as =Date < today() ) and then activate the bookmark and the associated advanced search on entry of app or a relevant tab through an action?

[#3]

Hi

No I have not. but how do you make the bookmark variable? Or how/where do you define that the bookmark should be ( =Date < today() )??

[Anonymous]

If you don't need today at all I would solve it in the loading script.
Just load the data up to yesterday.

You can do this by adding something like the line below to your loadscript.

Where DATEFIELD < day(today()) ;

[#5]

Hi

I have thought of that, but I need today. I do just not want to display it when my people is opening the file.

So I can only think of using a trigger. But It will not work for me

[Anonymous]

Hi Bjarne,

Have you tried an calculated dimension? That should work imo.

Just use something like below:

=IF(Date<Today(), Dimension)

[Anonymous]

And check Suppress when value is Null.

[rahulgupta]

Hey hi,

In this case you can use set analysis...

=sum( {<Day = {"*"} - {$(=today())} Sales )

Hope this works...

[#9]

Hi

Where do I see or find this calculated dimension?

[#10]

Hi

Where do I see/find this set analysis?