Completed Quarter

[dunnalahk]

HI,

In my Qlik Sense Report i am writing some expression as below.

i have categorized all percentage metrics into one flag and all numerical volumes into another flag as per below

the 2 variables i wrote for rolling Quarters

vMinMonth

vGetMaxQuarterMonthFinal

My Quarter values is always sum of 3 months

now what happening is when it comes to quarter ending last month

out of 10 Metrics  8 metrics data will come in time and under Q220  ----- so no problem it will give sum of 3 months Number.

but remaining 2 metrics data for last month of Quarter will be delayed .

So , it creates confusion to user's as they are thinking its complete Quarter number and using the QTD Number.

So now what i need is unless it has Sum of 3 months data i should not see the value for that metric under Q220  as per below snapshot

 how can i write ?

If ( MAX ( {<ScenarioLabel={'Actuals'},Scope={'APS'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} APSMetric_Flag ) = 1,

num ( SUM ({<ScenarioLabel={'Actuals'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"},Scope={'APS'}>} NumValue) /
SUM ({<ScenarioLabel={'Actuals'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"},Scope={'APS'}>} DenValue), '0.#%')

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

If ( MAX ( {<ScenarioLabel={'Actuals'},Scope={'APS'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} APSMetric_Flag ) = 2,

num ( SUM ({<ScenarioLabel={'Actuals'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"},Scope={'APS'}>} NumValue),'##,###.0')

[dunnalahk]

Hi All,

Basically i need to show completed quarter , where it has all 3 months data for that particular quarter else it should shoe blank .

unless 3 months data is there it should show blank

[dunnalahk · Accepted solution]

Hi

i added one more if condition as below

IF( MAX( {$<WW=,Region=, Geography=, SubGeo1=, SubGeo2=, Country=,Area=,QBR=,Month=,FY_Month=,FY_QM=,FY_Quarter=,Quarter=,FYear=,QuarterID=>} Month)>=$(vGetMaxQuarterMonthFinal),

it works what i need.