Completed Quarter

dunnalahk — Wed, 25 Nov 2020 16:16:04 GMT

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')

Re: Completed Quarter

dunnalahk — Sun, 31 May 2020 14:23:46 GMT

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

Re: Completed Quarter

dunnalahk — Mon, 01 Jun 2020 18:01:29 GMT

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.

topic Re: Completed Quarter in QlikView

Completed Quarter

Re: Completed Quarter

Re: Completed Quarter