Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
LDenivelle
New Contributor II

Create QVD with Qlik Tables

Hi

I have a table containing all the information to create QVD (see below).

data_table.PNG

TableDest = concatenation of "Table" and "SousTable". Contains the final name for my QVD.

Code = name of my first column. Contains all the Code (id)

Libellé = name of my second column. Contains all the Libellé

For example, I want to create table perimetre_perimetre (first row of "TableDest"). The final Result would be :

 

example.PNG

I started to do this :

TableauClean:
 NoConcatenate
 load
    *,
    Table&'_'&SousTable as TableDest
    
Resident CalculTables
where not isnull(Code);
DROP Table CalculTables;

FOR i = 0 to NoOfRows('TableauClean')-1
        
    LET TableNameDest = peek('TableDest', i, 'TableauClean');
  
'$(TableNameDest)':
    NoConcatenate LOAD
    Code,
    Libellé
    
    Resident TableauClean
    where TableDest = $(TableNameDest) //doesn't work !
    ;
    
//store $(TableNameDest) into $(vPathQVD_Dev)\$(TableNameDest).qvd;
//CALL Recapitulatif('$(TableNameDest)');
//drop Tables $(TableNameDest);
NEXT

Everything works except at the end when I want to specify which row I want to load for the table :

where TableDest = $(TableNameDest) //doesn't work !

 If I do it manualy like this :

where TableDest = 'perimetre_perimetre' //it works !

Maybe there is another way to create all the tables and generate QVD. Let me know !

 

Regards

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Create QVD with Qlik Tables

Try: where TableDest = '$(TableNameDest)'

talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Create QVD with Qlik Tables

Try: where TableDest = '$(TableNameDest)'

talk is cheap, supply exceeds demand
LDenivelle
New Contributor II

Re: Create QVD with Qlik Tables

haha

how to lose time for 2 quotes 😄

Thanks a lot !