Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello hello,
I want to calculate the portfolio but I get an error in my expression.
COUNT (IF(MonthYear_Start<=Master_MonthYear AND
Relevant_Sales=1 AND
Contract_Status_Code -=0 AND
Contract_Status_Code -= 10 AND
(ISNULL(Month_End_Real)=-1 OR MonthYear_End_Real>=Master_MonthYear)), Contract_Key)
Error: "Error in expression: ')' expected"
I hope/think its a small mistake but I don't get it
Is it right that -= is in Qlik Sense the new <> (NOT EQUAL)?
=COUNT(
IF(MonthYear_Start<=Master_MonthYear AND Relevant_Sales=1 AND Contract_Status_Code <> 0 AND Contract_Status_Code <> 10 AND
(ISNULL(Month_End_Real)<> 1 OR MonthYear_End_Real >= Master_MonthYear), Contract_Key))
We modified our data model to a canonical date like here: Canonical Date
After that it was simple to calculate it.
Thank you anyway!!