topic Re: If statement in App Development

If statement

ajit_aarya — Mon, 27 Jun 2022 18:16:14 GMT

This is my table,

And i need population count of portland from AZ state

i Tried this

Count(If(match(city, 'portland' and state, 'AZ') Population)) but its not working

city	state	population
portland	ME	10
chicago	IL	27
portland	AZ	21
portland	MI	51

Re: If statement

Qlik_Eric_Thomas — Mon, 27 Jun 2022 18:39:39 GMT

Try using Set Analysis instead, something like:

Sum({<city={'portland'}, state={'AZ'}>}Population)

Re: If statement

ajit_aarya — Mon, 27 Jun 2022 18:46:19 GMT

That works..

but what if we wanna print that

like i want city field where city is portland and state is AZ

If({<city={'portland'}, state={'AZ'}>}City)

Will this works??

Re: If statement

Qlik_Eric_Thomas — Mon, 27 Jun 2022 19:17:44 GMT

The Expression I gave should give you the population for Portland, AZ and just that. If you use that expression in a KPI, that's exactly what I will show.

If you replaced the 'Population' field in the table with my expression, you should only see 1 row.

Re: If statement

ajit_aarya — Mon, 27 Jun 2022 20:08:41 GMT

I want to locate a city in map chart with using both city name and state name.

***Consider there is a city portland in ME state**

In map chart, There this location field,

In chart, i want only portland from ME but there are few different portlands in different states,

When i am using a AND function like If(mixmatch(city,'Portland' and state,'ME'),City)

that syntax is not working