topic Set Analysis question in QlikView

Set Analysis question

Tue, 21 Jun 2011 20:57:10 GMT

Hello,

Can anyone help me with this expression?

The first part of the expression is ok, the problem is the second part after the multiplication sign.

I want = Tqte * Pontos_FT but only 700 | 0009 reference Pontos_FT

Thanks

Rodrigo

if(Dt_fase_Retorno < '0', sum ({$<Fase={'RISCO'}>} {$<Oficina={'MW-RISCO'}>} TQte

({$<Material_detail_id ={'700 | 0009'}>} Pontos_FT)))

Miguel_Angel_Baeyens — Tue, 21 Jun 2011 21:06:25 GMT

Hello Rodrigo,

According to the set analysis syntax, something like the following should work

Sum({< Fase = {'RISCO'}, Oficina = {'MW-RISCO'}, Dt_fase_Retorno = {"<0"} >} TQte) * Sum({< Material_detail_id = {700, 0009} >} Pontos_FT)

Hope that helps

BI Consultant

Tue, 21 Jun 2011 21:24:05 GMT

Hi Miguel,

Thanks for reply. But didn't work. Returned zero for all lines.

I need to multiply line by line like the expression below...

sum (TQte * Pontos_FT)

Not like the expression below...

sum (TQte) * sum(Pontos_FT)

Did you get it?

Regards,

Rodrigo