topic Re: Problem using the same field in set analysis and conditional? in QlikView

Problem using the same field in set analysis and conditional?

Fri, 31 Jul 2015 19:30:39 GMT

I have this calculated value:

(SUM({<AGRUPA_CONCEPTO={BONIFICACIONES_TOTAL}>}VALOR)/1000)/(SUM({<CONCEPTO = {GROSS_SALES} >}VALOR) / 1000)

And it's working

But when i try to do this it doesn't work. I don't know why. It doesn't show the field.

if (AGRUPA_CONCEPTO= 'POR_BONIF',

(SUM({<AGRUPA_CONCEPTO={BONIFICACIONES_TOTAL}>}VALOR)/1000)/(SUM({<CONCEPTO = {GROSS_SALES} >}VALOR) / 1000),

SUM(VALOR) / 1000)

This is because i'm using the same field in the set analysis and in the if conditional? I used this with an 1 and it works. Do you know why this isn't working?

Thank you

Greetings

Re: Problem using the same field in set analysis and conditional?

sunny_talwar — Fri, 31 Jul 2015 19:32:36 GMT

Try this:

If(CONCEPTO = 'POR_BONIF',

(SUM({<AGRUPA_CONCEPTO={BONIFICACIONES_TOTAL}>}VALOR)/1000)/(SUM(TOTAL {<CONCEPTO = {GROSS_SALES} >}VALOR) / 1000),

SUM(VALOR) / 1000)

Re: Problem using the same field in set analysis and conditional?

Fri, 31 Jul 2015 19:36:36 GMT

Thank you! but it didn't work. It's the same with or without total

Greetings

Re: Problem using the same field in set analysis and conditional?

sunny_talwar — Fri, 31 Jul 2015 19:38:47 GMT

What are you seeing 0 or - when you use your expression?? Can you try them as two separate expressions and see which one isn't working??

If(CONCEPTO = 'POR_BONIF', (Sum({<AGRUPA_CONCEPTO={BONIFICACIONES_TOTAL}>}VALOR)/1000))

If(CONCEPTO = 'POR_BONIF', (Sum(TOTAL{<CONCEPTO = {GROSS_SALES} >}VALOR) / 1000))

See which one isn't working

Re: Problem using the same field in set analysis and conditional?

Fri, 31 Jul 2015 19:44:52 GMT

I don't see 0 or -.

directly i don't see the dimmension 'POR_BONIF'

I see only the else, the 'VALOR)/1000)'

Re: Problem using the same field in set analysis and conditional?

sunny_talwar — Fri, 31 Jul 2015 19:48:29 GMT

You don' see the the dimension 'POR_BONIF'?? Why not?? I don't really undertand the issue here, can you share a screenshot of what you are seeing???

Re: Problem using the same field in set analysis and conditional?

antoniotiman — Fri, 31 Jul 2015 19:59:41 GMT

If BONIFICACIONES_TOTAL and GROSS_SALES are Fields try to use P() in Set Analysis

AGRUPTA_CONCEPTO=P(BONIFICACIONES_TOTAL)

CONCEPTO=P(GROSS_SALES)

Re: Problem using the same field in set analysis and conditional?

Fri, 31 Jul 2015 20:01:16 GMT

The field POR_BONIF. yeah, i don't see it.

Because the first part of the expression isn't working

Re: Problem using the same field in set analysis and conditional?

sunny_talwar — Fri, 31 Jul 2015 20:02:49 GMT

So this expression isn't working?

If(CONCEPTO = 'POR_BONIF', (Sum({<AGRUPA_CONCEPTO={BONIFICACIONES_TOTAL}>}VALOR)/1000))

Re: Problem using the same field in set analysis and conditional?

maximiliano_vel — Fri, 31 Jul 2015 20:15:50 GMT

Can you send us a sample of your data??