Create a bookmark

Wed, 25 Nov 2015 09:17:36 GMT

I have a report based on sales YTD. How do I create a bookmark that show all customersnumbers

that has YTD>4000. My calculation for YTD is Sum({$<$(vSetYTD)>} [DebPris]/100) .

To be able to create a bookmark I tried to connect a macro to a button to achieve the right customers and then

create the bookmark of it, but I always get all customers.

sub StatKunder

set f=ActiveDocument.GetField("[KundNr]")

f.Select "Sum({$<$(vSetYTD)>} [DebPris]/100)>4000"

end sub

What do I do wrong or is it an easier way to do it?

kindly

Håkan

Re: Create a bookmark

Gysbert_Wassenaar — Wed, 25 Nov 2015 09:36:40 GMT

Add a Select in Field action to the button and use your field KundNr and search string ='=Sum({$<$(vSetYTD)>} [DebPris]/100)>4000' as parameters. And add a Create Bookmark action to the button too. No need for macro's.

topic Re: Create a bookmark in QlikView

Create a bookmark

Re: Create a bookmark