Conditional Date Selection

[PatChaney]

Hi, new to Qlik Sense and wondering if anyone can help.

I have a select date range function and  would like to make the date field used conditional on the value of another field. So if Field A = 'PAID' use Date Field 1, otherwise use Date Field 2. Tried all combinations of the IF function and can't get it to work.

Any suggestions would be appreciated.

[Spivey]

Technically all you'd need to use is something like:

=if([someField]= 'PAID', [DateABC], [DateXYZ])

 Just make sure you aren't trying to show dates that are not distinct for the dimensions you're using.

Here's a table where [OrderID] has only one possible [DateABC] for each record:

OrderID	Status	DateABC
A016	PAID	3/21/2019
F073	OVERDUE	2/9/2019
K108	PAID	9/2/2020

But here's that table where [OrderID] is removed -- the [Status] dimension can have multiple [DateABC] values for each record and so the [DateABC] shows NULLs:

Status	DateABC
PAID	-
OVERDUE	-

[PatChaney]

Thanks very much for your reply, I thought I had tried that but will try again as per your example.