topic Fulfill condition in QlikView

Fulfill condition

Anonymous — Wed, 29 Oct 2014 15:24:58 GMT

Hi All

I have one conditional diagram as below

If(Zip=11378, 'New York',

if(Zip=11377, 'New York',

if(Match(Zip, 11377,11378), 'Queens')))

The third condition for 'Queens' not filfilled out because above two condition. How do I please?

Thanking you all

Re: Fulfill condition

alexandros17 — Wed, 29 Oct 2014 15:27:55 GMT

What kind of descriprion you want when zip = 11378 or 11377 New York or Queens?

Or Queens has precedence on New york?

Let me know

Re: Fulfill condition

Wed, 29 Oct 2014 15:32:44 GMT

Read them logically

The third condition will never be fulfilled as it will always be satisfied by one of the two prior

Re: Fulfill condition

Anonymous — Wed, 29 Oct 2014 15:50:27 GMT

Hi Alessandro

Basically Queens is suburb of New York. Zip 11377 and 11378 belong to Queens.

Same way Bronx is also suburb of New York and having Zip let say 12377, 123788

As Queens & Bronx are Suburb of New York so I want both in one chart and one column

Thanks for

Re: Fulfill condition

Anonymous — Wed, 29 Oct 2014 15:51:07 GMT

Hi Felim

I agree for this but any other way?

Thanks

Re: Fulfill condition

Anonymous — Wed, 29 Oct 2014 15:56:36 GMT

If I simplyfy

If I have data like

Zip Suburb Population

11377 Queens 100K
11378 Queens 110K

Req is

11377 100K

11378 110K

11377 or 11378 220K

No groups here simply chart

Re: Fulfill condition

alexandros17 — Wed, 29 Oct 2014 15:57:51 GMT

Ok but with a unique number you cannot have more description so the best to do is:

If(Zip = 11377 or Zip = 11378, 'Queens - New York',

If(Zip = 12377 or Zip = 12378, 'Bronx - New York',

,'Other'

)

Re: Fulfill condition

jpenuliar — Wed, 29 Oct 2014 16:01:32 GMT

As you mentioned Queens, Bronx is a Suburb of New York(which is a City), therefore move New york to a different table/field. think of it as adress1, adress2, POST CODE, town, city, prov, state etc.. unless there is a suburb called New York, which makes New York, New York city. how about that?

Re: Fulfill condition

jpenuliar — Wed, 29 Oct 2014 16:02:44 GMT

you could concatenate

Re: Fulfill condition

Wed, 29 Oct 2014 16:11:08 GMT

To be honest you could order by suburb and use the peek function to see if the previous row has changed and calculate it like that or create a summary table and use a group by?