topic Bookmark Max Data in QlikView

Bookmark Max Data

Anonymous — Mon, 08 Sep 2014 14:12:47 GMT

Hello Guys,

I have a bookmark, which filter Areas. But i want include or create a bookmark which filters my variable maxDate ( max(Date)).

Every day i need to filter year, month and day. I want to only select the Bookmark calling my variable maxDate.

Thanks

Re: Bookmark Max Data

maleksafa — Mon, 08 Sep 2014 14:17:33 GMT

you can create a bookmark to filter on the max(date) by using the advanced search expression on the date field.

1) add a new label with Date as dimension

2) right click on the object and go to advanced expression

3) write the expression there and hit go

4) create the new bookmark that will call this expression.

Re: Bookmark Max Data

Anonymous — Mon, 08 Sep 2014 14:26:10 GMT

Hello Malek,

Thanks for you answer, but this doesnt resolve my problem.

I actually have 20 reports, and need to filter all of them with a different bookmark. So i need to filter by region and with a variable MaxDate.

The problem is this :

If i bookmark a region, it always get max date. But if i select a previous month, it still gets the actual month, not the previous.

And i cant select area by area, date by date, because we are using a macro to generate these reports.

Is this possible?

Thanks !

Re: Bookmark Max Data

JonnyPoole — Mon, 08 Sep 2014 14:31:44 GMT

Hi - i am wondering if you just need to take the '=' sign out of your variable definition. If your variable is something like this:

=max(Date)

try changing it to this:

max(Date)

that way the expression text is injected into your other expressions first before calculating it the overall expression. you will probably need dollar sign expansion $(vMaxDate) to invoke the variable (in this example named 'vMaxDate').

Re: Bookmark Max Data

Anonymous — Mon, 08 Sep 2014 14:35:56 GMT

Hello Jonathan,

Thanks for the answer.

Is possbile apply my variable in the bookmark ?

Thanks

Re: Bookmark Max Data

Anonymous — Mon, 08 Sep 2014 14:40:57 GMT

Hello Guys,

I've solved it.

When we apply a bookmark, it overwrite all the other selections. So i've done, is edit the bookmarks, and check the option '+'.

Before, if i have the 2014 selected and apply bookmark x, the selections stay only 'x'.

Now, is my selection AND the bookmark.

Thank all of you !