topic Re: how to use Bookmark in a script ? in QlikView

how to use Bookmark in a script ?

Thu, 15 Oct 2015 09:54:23 GMT

Hello !

i would like to use a precedent saved bookmark in a qlikview project in order to create a table. Here is an exemple : my bookmark name is S1

LOAD idcli_horus,

ID,

Dans 11

FROM

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

SumData:

LOAD

replace(count( {@} [Dans11]),'@','S1') as Salary

RESIDENT Table1;

Let vSalary = peek('Salary',0,'SumData');

DROP TABLE SumData;

Load * Inline [

Gender, Type, Expected, Observed

Male, Bons, $( vSalary),4000

Male, Tous, 6191,6191];

The probleme is that the script doesn't take into account the bookmark S1 and use instead the total selection {1}.

Please Help me !!

thank you

Am'

Re: how to use Bookmark in a script ?

fkeuroglian — Fri, 16 Oct 2015 01:25:31 GMT

You cant do this, this will not work because when you run your script the bookmark is not created yet.

pherphaps you can try to do using variables, and you will have the same result

good luck

Fernando

Re: how to use Bookmark in a script ?

jonathandienst — Fri, 16 Oct 2015 05:31:41 GMT

A bookmark is a selection from your data model. At the time the script is running there is no data model and no selections, so there is no way to use the bookmarked selections during the reload.

For the same reason, set analysis does not work in the reload script either.

Perhaps you should explain what you are trying to do.

Re: how to use Bookmark in a script ?

Anonymous — Fri, 16 Oct 2015 05:41:14 GMT

Not possible . .

Re: how to use Bookmark in a script ?

avinashelite — Fri, 16 Oct 2015 05:54:43 GMT

You can try with some workarounds , like store your bookmark info as the text file or excel file and you utilize that info in your load script. Their is no direct way to do this.

Get Bookmark ID by Name

Re: how to use Bookmark in a script ?

Fri, 16 Oct 2015 06:05:01 GMT

You can't use set analysis in QlikView script. Set analysis works in expression only

Re: how to use Bookmark in a script ?

Mon, 19 Oct 2015 08:57:16 GMT

Thank's every one for your answers ! I found another way to do that !

Re: how to use Bookmark in a script ?

avinashelite — Tue, 20 Oct 2015 07:00:33 GMT

can you please share your solution, so that it will be useful for other too and please mark the helpful and correct answer too

Re: how to use Bookmark in a script ?

Tue, 20 Oct 2015 11:44:18 GMT

My purpose by creating a bookmark was to create a table that countains the caracteristics of my selection in order to run a chi2test on it (this test work just with row and column so with a pre-downloaded table). My solution was to not use the qlikview chi2 fonction. Unstead, I made this test my self by using variables.