Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk
Contributor III
Contributor III

Completed Quarter

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

1 Solution

Accepted Solutions
dunnalahk
Contributor III
Contributor III
Author

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.

View solution in original post

2 Replies
dunnalahk
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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.

View solution in original post