topic Line Chart for showing 12 months in QlikView

Line Chart for showing 12 months

Mon, 14 Dec 2015 15:31:16 GMT

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 !!

Re: Line Chart for showing 12 months

robert_mika — Mon, 14 Dec 2015 16:32:50 GMT

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)

Re: Line Chart for showing 12 months

Tue, 15 Dec 2015 14:09:01 GMT

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 ...