topic Loading from QVD file with Conditionals in QlikView

Loading from QVD file with Conditionals

Sat, 23 May 2009 00:05:27 GMT

Hello, i want to know if its possible to load data from a QVD file usig some conditionals. For example, what do i if i wat to load only data with the column ID_Job = '007' ?

Do i use 'case', 'if' or something like that? plase, an example would it great. Thanks

Loading from QVD file with Conditionals

rbecher — Sat, 23 May 2009 00:26:21 GMT

Just use a Where Clause like this:

LOAD
...
FROM [<qvd-file>] (qvd)
WHERE ID_Job = '007';

Ralf

Loading from QVD file with Conditionals

Sat, 23 May 2009 00:40:34 GMT

Thank you, Ralf. I made a mistake explaning my problem. I want to add special columns from calculated values using coditionals. Here's my script using a data source:

HNUA04:
LOAD *, "HnuA04_16P",
HnuA04PCOp,
"HnuFA3_01C",
C_ActPond_Riesgo, C_PatrimonioEfec,
C_ColoMes_SF, C_CastigoAnual;
SQL SELECT *, HnuA01_01A * 100 + HnuA04_01M Periodo,
Case When HnuFA3_01C = 9500 Then HnuA04_15P Else 0 End As C_ActPond_Riesgo,
Case When HnuFA3_01C = 9501 Then HnuA04_15P Else 0 End As C_PatrimonioEfec,
Case When HnuFA3_01C = 9502 Then HnuA04_15P Else 0 End As C_ColoMes_SF,
Case When HnuFA3_01C = 9503 Then HnuA04_15P Else 0 End As C_CastigoAnual
FROM "DWH_MIS".dbo.HNUA04;
Store HNUA04 Into HNUA04.qvd;
Drop Table HNUA04;

As you can see, i use "case when" because the SQL connector can read this command over my "DWH_MIS".dbo.HNUA04 resource. But what if i use a QVD file as source? I can't use the 'SQL SELECT' nor 'CASE WHEN'. The thing is that i want to the the same load within using a .dbo source; i would like to use a QVD file as source, but i have problems with sintaxis.

Thanks.

Loading from QVD file with Conditionals

johnw — Sat, 23 May 2009 00:47:43 GMT

Looks like the if() statement is what you're looking for:

LOAD
...
,if(HnuFA3_01C = 9500,HnuA04_15P,0) as C_ActPond_Riesgo
,if(HnuFA3_01C = 9501,HnuA04_15P,0) as C_PatrimonioEfec
...
FROM MyQVD.qvd (QVD);

Loading from QVD file with Conditionals

rbecher — Sat, 23 May 2009 00:49:40 GMT

You can use if() function:

LOAD
...
if(HnuFA3_01C = 9500, HnuA04_15P, 0) as C_ActPond_Riesgo,
...
FROM [<qvd-file>] (qvd);

Ralf

Loading from QVD file with Conditionals

Sat, 23 May 2009 01:09:14 GMT

Thank you, Ralf and Jhon 😄 It runs!

Greetings from Peru!