Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More

Dual function in Qlik Sense


I have the following function in my script which I used for Qlik View before. Now I would like to transfer that script to Qlik Sense but some function like e.g. Dual seem not to work in Qlik Sense. As I got this function from a consultant I´m not sure what dual does. Is anybody able to change it:

Dual('Q' & Ceil(Month(CloseDate)/3) & '-' & Right(Year(CloseDate),2), Year(CloseDate) & Ceil(Month(CloseDate)/3)) as [Opportunity Close Quarter/Year],

Further I have the following function:

if(IsClosed = 'false' and CloseDate >= '$(vExecTime)', 'OPEN', 'CLOSED') as [Opportunity Status]

Is this the correct translation, because Qlik Sense seems not to work with "and":

if(IsClosed = 'false', if( CloseDate >= '$(vExecTime)', 'OPEN', 'CLOSED')) as [Opportunity Status],

Many thanks in advance.


1 Reply

Re: Dual function in Qlik Sense

May be this for Dual function:

Dual('Q' & Ceil(Month(CloseDate)/3) & '-' & Right(Year(CloseDate),2), QuarterYear(CloseDate)) as [Opportunity Close Quarter/Year],

And this for translation:

If(IsClosed = 'false', If(CloseDate >= '$(vExecTime)', 'OPEN', 'CLOSED'), 'CLOSED') as [Opportunity Status],