topic Re: Same value not evaluated in QlikView

Same value not evaluated

Anonymous — Fri, 27 Mar 2015 22:06:56 GMT

Hi All

How to evaluate same value of row. Please have a look on the screen and attached QV sample

The circled red are not evaluating as already initially. Is there any way for?

Thanks a lot

Re: Same value not evaluated

MK_QSL — Fri, 27 Mar 2015 22:12:13 GMT

If(Match(City,'Buffalo', 'Rochester', 'Syracuse'), 'WNY',

If(Match(City,'New York','Yonkers'), 'SNY',

If(Match(City,'Edison'), 'ENJ',

If(Match(City,'Elizabeth', 'Union'), 'WNJ', null()))))

Re: Same value not evaluated

fred_s — Fri, 27 Mar 2015 22:18:25 GMT

I'd add 'Zone' to the script, keep IT simple 😉

Grtz Fred

Re: Same value not evaluated

Anonymous — Fri, 27 Mar 2015 23:50:06 GMT

Manish

This is fine but the question is like

If 'A' than -> 'ABC'

but if A & B than 'ABCDE'

In this case 'A' is already evaluated so in next condition 'A' not fulfill

Thanks

Re: Same value not evaluated

Anonymous — Fri, 27 Mar 2015 23:53:04 GMT

Hi Fred

I appreciate your reply. But in my QV there are 150 line items.

Some of them replicate with other line item combination.

For that I need to have some solution so fulfill the condition.

Thanks

Re: Same value not evaluated

anbu1984 — Sat, 28 Mar 2015 05:22:33 GMT

If you have 'A', then is your expected output is 'ABC' and 'ABCDE'??

Re: Same value not evaluated

pokassov — Sat, 28 Mar 2015 06:49:03 GMT

Hi Satish!

If you don't want to change field"City", you can

1. Add another field "KeyCity"

2. Add second table with zone

there is the script:

t1:

LOAD * INLINE [

City

Buffalo

Rochester

Syracuse

New York

Yonkers

Edison

Union

Elizabeth

];

t2:

LOAD

City as City,

City as KeyCity

Resident t1;

DROP Table t1;

t3:

LOAD * Inline [

KeyCity, Zone

Buffalo, NY

Rochester, NY

Syracuse, NY

New York, NY

Yonkers, NY

Edison, NJ

Union, NJ

Elizabeth, NJ

Buffalo, WNY

Rochester, WNY

Syracuse, WNY

New York, SNY

Yonkers, SNY

Edison, ENJ

Union, WNJ

Elizabeth, WNJ

];

Re: Same value not evaluated

MK_QSL — Sat, 28 Mar 2015 08:53:18 GMT

What is the output you are looking for?