Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

satishkamath
Contributor II

Fulfill condition

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

9 Replies

Re: Fulfill condition

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

Not applicable

Re: Fulfill condition

Read them logically

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

satishkamath
Contributor II

Re: Fulfill condition

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

satishkamath
Contributor II

Re: Fulfill condition

Hi Felim

I agree for this but any other way?

Thanks

satishkamath
Contributor II

Re: Fulfill condition

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

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'

)

)

jpenuliar
Valued Contributor III

Re: Fulfill condition

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?

jpenuliar
Valued Contributor III

Re: Fulfill condition

you could concatenate

Not applicable

Re: Fulfill condition

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?

Community Browser