Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
alexandros17
Partner - Champion III
Partner - Champion III

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
Author

Read them logically

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Hi Felim

I agree for this but any other way?

Thanks

Anonymous
Not applicable
Author

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

alexandros17
Partner - Champion III
Partner - Champion III

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
Partner - Specialist III
Partner - Specialist III

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
Partner - Specialist III
Partner - Specialist III

you could concatenate

Not applicable
Author

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?