case when?

[Anonymous]

Hola, intento crear una variable en el proceso de carga de datos a través de "Case When". Soy nueva en el QlikView, alguien me puede ayudar:

Select Ciclo,

Tipo_item,

Mes_uso,

Fact,

case when (Ciclo<>`ciclo01` and Tipo_item=`Cuotas` and Mes_uso='201407') then (Fact+Fact*0.33333) else Fact end as  Efecto_c

from Tabla

Muchas gracias

[sujeetsingh]

if(Ciclo<>`ciclo01` and Tipo_item=`Cuotas` and Mes_uso='201407'),(Fact+Fact*0.33333),Fact) as  Efecto_c

[jonathandienst]

Hi

Select Ciclo,

  Tipo_item,

  Mes_uso,

  Fact,

  If(Ciclo<>'ciclo01' and Tipo_item='Cuotas' and Mes_uso='201407', Fact * 1.333333, Fact) As Efecto_c

from Tabla

HTH

Jonathan

[Anonymous]

Gracias pero no funciona, el error es el siguiente:

[antoniotiman]

You can't use if() in SQL Sintax.

If()  is QV Sintax.

Your Sintax SQL is correct.

In QV -> Preceding LOAD

Table:

Load *,

If(Ciclo <> 'ciclo01' and ... and..., Fact*1.33333,Fact) as Efecto_c;

SQL Select

Ciclo,

Tipo_Item,

Mes_uso,

Fact

from Tabla;

Hola,

Antonio

[anbu1984]

From Google translate

Hello, I try to create a variable in the process of loading data through " Case When " . I am new to QlikView , someone can help me:

Do you have any issue in Case when?

If statement suggested above is for qlikview.

[antoniotiman]

Ciao Mihaela,

ho notato che usi ODBC per EXCEL.

In QV Script puoi caricare direttamente il Foglio Excel.

Vai in Script, Inserisci -> Istruzione di LOAD -> Carica da File. Segui il Wizard, Conferma.

Inserisci manualmente l' istruzione

If(Ciclo <> 'ciclo01' and ... and..., Fact*1.3333,Fact) as Efecto_c.

Hola,

Antonio

[Anonymous]

Antoni Thanks, it worked. I did as you told me.

I put here the solution for anyone with the same problem, thanks!!!

[Anonymous]

I need to create another field using the new (Efecto_c), would be something like:

sum(If(Mes_uso='201407',`Efecto_c`,0) - If(Mes_uso='201406',`FN_FZ_con_FV`,0)) as Efecto_d

I have to group by all fields unless Mes_uso.

But I don't know where to put this formula, in the Script or in the expression of a pivot table?

[antoniotiman]

In the script.