topic Re: Modifier based on another field in QlikView

Modifier based on another field

Sat, 06 Feb 2016 17:48:15 GMT

Hello;

I need to modify a field based on another field, in order to find the right number to compare with.

It works with a constant number (marked in red) but it does not work with the field, which is [Nuevo nivel resp.] (and at the same time is the Dimension).

IF([Fijo revisado] <

Only(TOTAL

{<[Número nivel]=

{

}

Mínimo),

RGB(0,255,0)

What canI write instead of "3". I have tried:

[Nuevo nivel resp.]

and

$(=[Nuevo nivel resp.])

Thanks.

Re: Modifier based on another field

Chanty4u — Sat, 06 Feb 2016 19:13:26 GMT

hi,

IF([Fijo revisado] < Only(TOTAL {<[Número nivel]= " { 3 }" >} Mínimo),

RGB(0,255,0)

Re: Modifier based on another field

HirisH_V7 — Sat, 06 Feb 2016 19:29:12 GMT

Hi,

Pls check in your Data,

Is there any Space Before or After the Value 3 .

Re: Modifier based on another field

sunny_talwar — Sat, 06 Feb 2016 19:36:25 GMT

Would you be able to share some data to understand how you data looks?

Re: Modifier based on another field

Sun, 07 Feb 2016 10:38:01 GMT

Hi all:

Instead of using a modifier based on another field I have decided to load two tables from the same Excel sheet. With this solution I can avoid complex programming.