Line Chart for showing 12 months

[#1]

Hey Guys,,

This is my expression in here :

if(Headline_Fig= 'Gross Margin', sum({<FY={$(vMaxYear_CompletePeriod)},Period={'>=$(=Min(Period))<=$(=Max(Period))'}, Flag={'Actual'},[Headline_Fig]={'Gross Margin'}>}Amt),

if(Headline_Fig= 'Controllable Contribution', sum({<FY={$(vMaxYear_CompletePeriod)},Flag={'Actual'},[Headline_Fig]={'Controllable Contribution'}>}Amt),

if(Headline_Fig= 'Gross Revenues', sum({<FY={$(vMaxYear_CompletePeriod)},Flag={'Actual'},[Headline_Fig]={'Gross Revenues'}>}Amt),

if(Headline_Fig= 'Net Revenue', sum({<FY={$(vMaxYear_CompletePeriod)},Flag={'Actual'},[Headline_Fig]={'Net Revenue'}>}Amt)))))

What do i need to change in here to make show values for previous 12 months ?

Thanks for the help.. Much appreciated.... Thanks indeed !!

[robert_mika]

Something like this:

if(Headline_Fig= 'Gross Margin', Sum({<FY={">=$(=MonthStart(today(),-12)))<=$(=Today())",Flag={'Actual'},[Headline_Fig]={'Controllable Contribution'}>}Amt)....

Feeling Qlikngry?

How To /Missing Manual(23 articles)

[#3]

Hey Robert,

Thanks for the help.

I tried this,

if(Headline_Fig= 'Gross Margin', sum({$<FY=, Period=, FYPeriod= {'>=$(=(Max(FYPeriod), -12)) <=$(=(Max(FYPeriod), 0))'}, Flag={'Actual'},[Headline_Fig]={'Gross Margin'}>}Amt),

Even this did not work ...