Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mhmmd_srf
Contributor

Legend is Not Visible

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

1 Solution

Accepted Solutions
franky_h79
Honored Contributor

Re: Legend is Not Visible

press ctrl+shift and drag the red line downwards:

Aufnahme_2017_06_19_13_17_30_947.gif

14 Replies
Highlighted
prat1507
Valued Contributor

Re: Legend is Not Visible

Hi

PFA the app.

Regards
Pratyush !

Re: Legend is Not Visible

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

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)

mhmmd_srf
Contributor

Re: Legend is Not Visible

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

You can use the example given by prat1507

Regards,

Kaushik Solanki

mhmmd_srf
Contributor

Re: Legend is Not Visible

Hi Anil,

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

mhmmd_srf
Contributor

Re: Legend is Not Visible

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

franky_h79
Honored Contributor

Re: Legend is Not Visible

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

May be this?

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