Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
CaseySBS
Contributor
Contributor

Count If with Multiple Conditions and Division

Greetings,

I'm trying to string together a formula that currently works as follows, however, I want to add another condition for BOTH counts. In another joined table, I have acquisition dates, and I want to only count units in the months after the acquisition date. Is this something anyone might know how to do? Any help would be greatly appreciated.

count(if([Unit Availability] = 'Unavailable',[uni_int_UnitId-unu_int_UnitId]))/Count(total <[LastDayOfMonth-unu_dtm_Datetime.autoCalendar.YearMonth]> ([uni_int_UnitId-unu_int_UnitId]))

Labels (1)
1 Reply
DavidFosterVF
Creator
Creator

Can you expand on your problem a bit more and explain what unu_int is?

From your description it sounds like adding set analysis into the expression e.g. {transaction_date > acquisition_date}