topic Re: Bookmarks with expression in QlikView

Bookmarks with expression

maleksafa — Thu, 12 Dec 2013 09:27:27 GMT

Hello,

is it possible to create a bookmark based on an expression having set analysis.

For example i have an expression that set the date to Date(Today() - 7)) ([Transaction Date] = Today() - 7)), i can do that in a button with select in Field of the transaction date and the value to be Today() - 7, but how can i do that in a bookmark?

Re: Bookmarks with expression

swuehl — Thu, 12 Dec 2013 09:45:22 GMT

If you use a search string in your selection action that is dynamic, the bookmark will be also dynamic (it just stores the search string, not the actual field values then).

Re: Bookmarks with expression

maleksafa — Thu, 12 Dec 2013 09:59:57 GMT

thank you for you reply, it worked in the advanced search but take for example the below complex experrions

min({1<[AZ Week]=P({1<[Transaction Date]= {"$(=date(Today()-7, 'DD-MMM-YYYY'))"}>} [AZ Week]), Year = P({1<[Transaction Date]= {"$(=date(AddYears(Today() -7,-1), 'DD-MMM-YYYY'))"}>} Year) >}[Transaction Date])) & '<=' & (max({1<[AZ Week]=P({1<[Transaction Date]= {"$(=date(Today()-7, 'DD-MMM-YYYY'))"}>} [AZ Week]), Year = P({1<[Transaction Date]= {"$(=date(AddYears(Today() -7,-1), 'DD-MMM-YYYY'))"}>} Year) >}[Transaction Date]))

if you put the expression in a button under the select in field it will generate a date between two values, so basically what i am trying to do is to get [Transaction Date] between two dates.

i have tried this in the advanced search but it will not return anything