topic Re: case when? in QlikView

case when?

Anonymous — Wed, 01 Oct 2014 09:08:59 GMT

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

Re: case when?

sujeetsingh — Wed, 01 Oct 2014 09:12:36 GMT

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

Re: case when?

jonathandienst — Wed, 01 Oct 2014 09:14:20 GMT

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

Re: case when?

Anonymous — Wed, 01 Oct 2014 09:43:41 GMT

Gracias pero no funciona, el error es el siguiente:

Re: case when?

antoniotiman — Wed, 01 Oct 2014 09:50:25 GMT

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

Re: case when?

anbu1984 — Wed, 01 Oct 2014 09:52:56 GMT

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.

Re: case when?

antoniotiman — Wed, 01 Oct 2014 11:15:43 GMT

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

Re: case when?

Anonymous — Wed, 01 Oct 2014 12:51:42 GMT

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

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

Re: case when?

Anonymous — Wed, 01 Oct 2014 13:57:25 GMT

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?

Re: case when?

antoniotiman — Wed, 01 Oct 2014 16:48:53 GMT

In the script.

Re: case when?

Mon, 06 Oct 2014 21:12:21 GMT

Hi Mihaela.

you can use somenting like this

you have now your first query then put a name :

test:

load...

from

then you can select it table with command resident:

load

sum(if(Mes_uso...))...

resident test

group by Clase_DB,....

;

Re: case when?

Thu, 23 Oct 2014 20:57:27 GMT

Hello! I am new to Qlikview also. I want to do a CASE statement in Editor. Is it done in the LOAD section? What is the syntax for a CASE? I need something like this:

Case when UNIT like 'CH%" then "C" else "?" end 'Facility'

Thanks for any help!

Leonard

Re: Re: case when?

MarcoWedel — Thu, 23 Oct 2014 21:59:40 GMT

as already stated, there is no case when command in QlikView, you have to use an

If(condition, expression true, expression false)

instead.

hope this helps

regards

Marco

Re: Re: case when?

MarcoWedel — Thu, 23 Oct 2014 22:01:42 GMT

or in your case:

LOAD somefields,

If(UNIT like 'CH', 'C', '?') as Facility

FROM yoursource;

Re: case when?

anbu1984 — Fri, 24 Oct 2014 02:01:38 GMT

Case statement is not available in Qlikview. Try "If" as Marco suggested.