Binary load

[qv_testing]

Hi All,

Binary Load:  loading data from another QVW file..

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

Thanks in Advance

[er_mohit]

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

[Anonymous]

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);

NEXT

//

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]