topic Re: Binary load in QlikView

Binary load

Nagaraju_KCS — Tue, 25 Jun 2013 04:40:32 GMT

Hi All,

Binary Load: loading data from another QVW file..

Without using Binary Load is there any another method...

Thanks in Advance

Re: Binary load

er_mohit — Tue, 25 Jun 2013 04:48:41 GMT

the another way is to make script file(qvs) for one qvw file and then you can open it in another qvw file

see the attached file here

the the application where i can modify al my table developing part done

press Ctrl + E //means go to script

file-->Export to script file then there's dilog box open for save the file name name that file

then ok

create another qvw where you insert that script file

in new qvw file first go to edit script-->Insert tab-->script file--> open that script file which you have made then press ok

again press ctrl + e

then you ll see your script file is same as that in presvious qvw file then reload and save that file

hope it helps you

Re: Binary load

Anonymous — Tue, 04 Feb 2014 18:52:20 GMT

Oi,

No exemplo a seguir, a partir do aplicativo [Governance Dashboard.qvw], desejo obter uma tabela do seu modelo e desejo armazená-la em um qlikview data file (qvd). Abra um script no seu aplicativo (Ctrl+E) e digite o seguinte:

Binary [Governance Dashboard.qvw]; // esta deve ser a primeira linha do script

SET vQVDSaveLocation='QVD\';

For i = 0 to NoOfTables()-1

Let vTableName = chr(39) & TableName($(i)) & Chr(39);

Tables:

Load $(vTableName) as TableName

AutoGenerate 1;

Next;

For i = 0 to (NoOfRows('Tables')-1)

LET vTable = '[' & Peek('TableName', $(i), 'Tables') & ']';

LET vQVDName = Peek('TableName', $(i), 'Tables');

// Tabela interesse: [SessionTaskAuditMaster]

IF vTable = '[SessionTaskAuditMaster]' THEN

Store $(vTable) into $(vQVDSaveLocation)$(vQVDName).QVD;

END IF;

Drop Table $(vTable);

Drop Table Tables;

// em seguida vamos criar uma entidade a partir do QVD gerado acima

Auditoria:

LOAD Floor(SessionDate) AS %DataID,

SessionDate,

DocName,

QlikView_User,

Session_Start,

Session_Duration,

Session_Start_Count,

SessionHour

FROM QVD\SessionTaskAuditMaster.QVD(qvd);

Agora posso referenciar essa entidade (Auditoria) em meus gráficos no novo aplicativo.

Antes de rodar este exemplo crie uma pasta para ele e nessa pasta crie outra pasta como nome "QVD". Copie do servidor o aplicativo [Governance Dashboard.qvw]