Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sarasmonu
New Contributor III

Display Latest Quarter in KPI

Hi ,

I want the latest Quarter to be display in the KPI object.

Example - "Q1-2018" . Quarter Column is coming from the table. Please let me know what function can be used to get the latest quarter value in the KPI object.

Thanks

1 Reply
prma7799
Honored Contributor III

Re: Display Latest Quarter in KPI

Try this

SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))}

,[Posting Date]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Sales Amount])

or

(SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))}

,[Posting Date]={">=$(=QuarterStart(max([Posting Date])))<=$(=max([Posting Date]))"}

>}[Sales Amount])

Community Browser