buffer loading

[#1]

Hi community!!

I´ve got a problem I´m sure you can help me to solve.

I´m creating a qlikview file to analyze some profit and losses data, and I think to use drill-down is the better way (in this case). But, when I created that account drill-down, some problems appeared like if I don´t have data in selected company and month no data will be shown,  but it will show data from other companies.

As that behaviour is not good, I thought the better way to solve that problem is to load all combinations of two specific tables with import 0 (with that solutions whatever I select, qlikview will find unless one loaded data)

My script is:

ODBC CONNET TO [MS ACCESS Database; DBQ=C:\.......\BI.mdb];

BUFFER LOAD LEFT(MES_BALANCE,4) AS AÑO,

              NUM(RIGHT(MES_BALANCE,2)) AS PERIODO,

               MES_BALANCE,

               0 AS IMPORTE,

               'RELLENO' AS DISC_APUNTE;

SQL SELECT MES_BALANCE

FROM PERIODOS;

OUTER JOIN

LOAD SOCIEDAD&'-'&CTA_MAYOR AS ID_SOCCTA,

     IMPUTACION;

SELECT DISTINCT SOCIEDAD, CTA_MAYOR, IMPUTACION

FROM 1004B_ANALITICA_QLIKVIEW;

That script only creates me buffer from first table, but not from both. What should I do?

Thanks for your help!!

Fiber9906

[kaushiknsolanki]

Hi,

   Try to  create a resident table  and use buffer load in that. For example.

   Data:

   SQL select

   ABC,

    XYZ

   from PQR;

   Data2:

    buffer load

   ABC as ABC1,

   XYZ as XYZ1

   Resident Data; 

   NOTE: Make sure that you cange the name in the resident table. Other wise your resident table will not be generated. The reason is qlikview updates the first table if the second table have same no. of fields with same name.

Regards,

Kaushik Solanki