topic Re: Avg refrence line in drill down group in QlikView

Avg refrence line in drill down group

sat_tok52 — Tue, 05 Jul 2016 09:19:12 GMT

Hi Guru's,

I am using time(Year,Month,Week) drill down group dimension in my line chart , i want to set avg refrence line for each dimension.I tried different ways but i won't get exact result.

any help.

Thanks,

Sateesh.T

Re: Avg refrence line in drill down group

MK_QSL — Tue, 05 Jul 2016 09:25:01 GMT

Use Something like below

=Avg(TOTAL Aggr(SUM(Sales),$(='[' & GetCurrentField(TIME) & ']')))

=Avg(Aggr(SUM(Sales),$(='[' & GetCurrentField(TIME) & ']')))

Replace SUM(Sales) with your expression

TIME with your Drill Down Group Name

Re: Avg refrence line in drill down group

sat_tok52 — Tue, 05 Jul 2016 09:34:56 GMT

Hi Manish,

Thanks for quick reply. it's not working.

Re: Avg refrence line in drill down group

MK_QSL — Tue, 05 Jul 2016 09:38:29 GMT

Provide sample data or sample app... Without that difficult to answer.