Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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