topic Re: Legend is Not Visible in QlikView

Legend is Not Visible

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one chart Dollar by Period. I have one Linear also in the chart.Which I have implemented with Trendline section.

But I am not able to enable Legend for those.

I am attaching my sample App.

Could you please help on this.

Thanks,

Sarif

Re: Legend is Not Visible

prat1507 — Mon, 19 Jun 2017 09:29:16 GMT

PFA the app.

Regards
Pratyush !

Re: Legend is Not Visible

kaushiknsolanki — Mon, 19 Jun 2017 09:34:00 GMT

Hi,

The Legend will be enabled when you have more than one expression or dimension. It will not enabled when you have one dimension and one expression.

Regards,

Kaushik Solanki

Re: Legend is Not Visible

Anil_Babu_Samineni — Mon, 19 Jun 2017 09:38:52 GMT

OR, You can use expression for 2nd one rather than Enable option called Linear for your 1st expression

linest_m(total aggr(CstFiscalPeriod,CstFiscalPeriod), CstFiscalPeriod)*CstFiscalPeriod + linest_b(total aggr(CstFiscalPeriod,CstFiscalPeriod),CstFiscalPeriod)

Re: Legend is Not Visible

mhmmd_srf — Mon, 19 Jun 2017 09:39:04 GMT

Ok..this is new learning for me. Thanks a lot dear.

But How to make Legend for Linear?

I want a legend for Linear like:

Total Dollar (Linear).

Please help on this.

Thanks,

Sarif

Re: Legend is Not Visible

kaushiknsolanki — Mon, 19 Jun 2017 09:43:53 GMT

You can use the example given by prat1507‌

Regards,

Kaushik Solanki

Re: Legend is Not Visible

mhmmd_srf — Mon, 19 Jun 2017 09:45:18 GMT

Hi Anil,

This is not showing correct result. It is showing a Straight Line on 0 value.

Re: Legend is Not Visible

mhmmd_srf — Mon, 19 Jun 2017 09:47:53 GMT

Hi Pratyush,

I got this. But what to do on Liner? I want a Legend on Linear also with Different Color.

Please help.

Thanks,

Sarif

Re: Legend is Not Visible

Frank_Hartmann — Mon, 19 Jun 2017 09:56:46 GMT

try this expression:

linest_m(total aggr(sum(ActualDollars),CstFiscalPeriod), CstFiscalPeriod)*CstFiscalPeriod + linest_b(total aggr(sum(ActualDollars),CstFiscalPeriod),CstFiscalPeriod)

hope this helps

Re: Legend is Not Visible

Anil_Babu_Samineni — Mon, 19 Jun 2017 09:59:57 GMT

May be this?

=linest_m(total aggr(sum(ActualDollars),CstFiscalPeriod),CstFiscalPeriod) * CstFiscalPeriod + linest_b(total aggr(sum(ActualDollars),CstFiscalPeriod),CstFiscalPeriod)

Re: Legend is Not Visible

mhmmd_srf — Mon, 19 Jun 2017 10:20:09 GMT

Hello Anil sir,

I did the same but Legend is not showing for Linear.

Is there any tricks I am missing?

Please help.

Thanks,

Sarif

Re: Legend is Not Visible

Frank_Hartmann — Mon, 19 Jun 2017 10:44:03 GMT

Re: Legend is Not Visible

prat1507 — Mon, 19 Jun 2017 11:07:14 GMT

Sorry for the late reply. I have done a work around to get legends on the chart. PFA the app. Though it won't point to the liner, but I couldn't figure out anything else.

Regards
Pratyush

Re: Legend is Not Visible

mhmmd_srf — Mon, 19 Jun 2017 11:11:54 GMT

Hello Frank,

I am doing the same thing. Still not visible.

Attaching the App.

Please help.

Thanks,

Sarif

Re: Legend is Not Visible

Frank_Hartmann — Mon, 19 Jun 2017 11:18:33 GMT

press ctrl+shift and drag the red line downwards: