topic Re: Line chart in QlikView

Line chart

stephenedberkg — Fri, 22 Jan 2016 07:47:00 GMT

in line chart i used below expression

=Sum({<Year={$(=Max(Year))},MonthID= {$(=Max(MonthID))},Year=,Month=>} Aggr(If(Only({1}MonthIDS) = Max(TOTAL <ID> MonthID ) + Only(TOTAL <ID> OrderLockPeriod) ,

Sum({<Year={$(=Max(Year))},MonthID= {$(=Max(MonthID))},Year=,Month=>}sales)), ID, MonthIDS ))

if i selected the month sep it displaying only the sep month values.

but i want to show all month till sep.

help me?

Ragards

Stephen G

Re: Line chart

Anonymous — Fri, 22 Jan 2016 07:51:20 GMT

Use Date Filterration for same?

Like, Year Start Date till Max Date Selected

Re: Line chart

stephenedberkg — Fri, 22 Jan 2016 07:53:00 GMT

could you please write it in the above expression?

Re: Line chart

Anonymous — Fri, 22 Jan 2016 08:08:18 GMT

Did you check these?

YTQ, QTD, MTD and WTD

Set Analysis for certain Point in Time

Clean explanation for same

Re: Line chart

effinty2112 — Fri, 22 Jan 2016 09:18:18 GMT

Hi Stephen,

It looks to me that the set modifier MonthID= {$(=Max(MonthID))} is preventing you seeing months prior to Sep when Sep is selected try replacing that with something like

MonthID = {"<=$(=Max(MonthID))"}

Good luck.

Re: Line chart

stephenedberkg — Fri, 22 Jan 2016 09:59:30 GMT

Dear Effinty2112

already i tried like that but i can't get it.