topic Re: If Statement with multiple conditions in App Development

If Statement with multiple conditions

robertsb41 — Thu, 16 Jul 2020 12:01:21 GMT

I am trying to create a calculated field based on multiple columns Contract ID, Bid Rank, and Amount. If Bid Rank = 2 then I want Amount displayed for each row of the Contract ID.

This displays the amount but only for the row where bid rank =2, If([Bid Rank]=2, Amount).

So what I am getting is:

Contract ID	Bid Rank	Amount	Low
27	1	250	-
27	2	350	350
27	3	450	-
62	1	10	-
62	2	20	20
62	3	30	-
62	4	40	-
73	1	100	-
73	2	450	450

What I want is:

Contract ID	Bid Rank	Amount	Low
27	1	250	350
27	2	350	350
27	3	450	350
62	1	10	20
62	2	20	20
62	3	30	20
62	4	40	20
73	1	100	450
73	2	450	450

Re: If Statement with multiple conditions

sunny_talwar — Thu, 16 Jul 2020 12:12:23 GMT

Try this may be

Sum(TOTAL <[Contract ID]> {<[Bid Rank] = {2}>} Amount)

Re: If Statement with multiple conditions

robertsb41 — Thu, 16 Jul 2020 12:19:22 GMT

Sum(TOTAL <[Contract ID]> {<[Bid Rank] = {2}>} Amount)

I get unrecognized symbol: {

Re: If Statement with multiple conditions

sunny_talwar — Thu, 16 Jul 2020 12:20:40 GMT

Really? Can you try this

Sum({<[Bid Rank] = {2}>} TOTAL <[Contract ID]> Amount)

Re: If Statement with multiple conditions

robertsb41 — Thu, 16 Jul 2020 12:23:40 GMT

Sum({<[Bid Rank] = {2}>} TOTAL <[Contract ID]> Amount)

I get unrecognized symbol: {

Re: If Statement with multiple conditions

sunny_talwar — Thu, 16 Jul 2020 12:24:14 GMT

Can you share an image of where we can see this error message?

Re: If Statement with multiple conditions

robertsb41 — Thu, 16 Jul 2020 12:27:16 GMT

Re: If Statement with multiple conditions

sunny_talwar — Thu, 16 Jul 2020 12:35:39 GMT

What kind of object are you using this in? Is this a table in Qlik Sense?

Re: If Statement with multiple conditions

robertsb41 — Thu, 16 Jul 2020 12:36:32 GMT

Your expression works in a straight table but not when adding a calculated field. Not sure how that makes sense.

Re: If Statement with multiple conditions

robertsb41 — Thu, 16 Jul 2020 12:40:17 GMT

Yes, just a simple table. There are multiple rows with the same [contract id] that are ordered by [bid rank] 1-n with different [amounts].

Re: If Statement with multiple conditions

sunny_talwar — Thu, 16 Jul 2020 12:40:29 GMT

calculated field? Meaning calculated dimension? Try this for calculated dimension

Aggr(NODISTINCT Sum({<[Bid Rank] = {2}>} Amount) , [Contract ID])

Re: If Statement with multiple conditions

robertsb41 — Thu, 16 Jul 2020 12:51:07 GMT

That did it. Thank you! I guess you cannot do this in data manager? Sorry, I've only been using Qlik for less than a month and not real savvy yet. Thanks again.

Re: If Statement with multiple conditions

sunny_talwar — Thu, 16 Jul 2020 12:55:08 GMT

Data manager is something which is available in Qlik Sense and I mostly have been working on QlikView. May be someone with more knowledge about Data Manager/Qlik Sense can answer this for you.