topic Limitting Legends in chart in QlikView

Limitting Legends in chart

gauthamchilled — Fri, 20 Nov 2020 18:02:30 GMT

I want to show 3 months data in the line chart. I want to show only monthend date as legend in chart instead of showing all the 90 dates.

Data for all 90+days..but date on legend only to show 3 monthend dates in the chart..how to achieve this?

Re: Legend in chart

krishna20 — Tue, 21 Jul 2015 09:36:02 GMT

Hi Gautham,

Please share some sample file.It will be easy to guide you.

Re: Legend in chart

help4qv123 — Tue, 21 Jul 2015 09:37:46 GMT

Share a sample so that we can help you

Re: Legend in chart

gauthamchilled — Tue, 21 Jul 2015 09:48:29 GMT

attached sample..

Re: Legend in chart

help4qv123 — Tue, 21 Jul 2015 10:02:26 GMT

=monthend(DateField)

Try this expression in Your chart dimension.

Re: Limitting Legends in chart

gauthamchilled — Tue, 21 Jul 2015 10:31:08 GMT

That is not my requirement. I want to show all the data in the chart, but only in the legend I want to show monthend dates. read again my requirement.

Re: Limitting Legends in chart

gauthamchilled — Tue, 21 Jul 2015 12:42:05 GMT

I tried using static min and static max in chart to achieve..i used min(monthend(date)) and max(monthend(date))..but in the legends it showing monthstart of date..strange to me..

but i use the same expression in texbox..it shows monthend date...

can anyone help?

Re: Limitting Legends in chart

qlikviewwizard — Tue, 21 Jul 2015 13:56:31 GMT

Hi gauthamchilled

Can you post your output in screen. It will help us for better understanding.

Re: Limitting Legends in chart

gauthamchilled — Tue, 21 Jul 2015 14:57:16 GMT

qlikviewwizard can you help me in getting all the data in the chart but the legend should show only monthend data not all the date for all the month? attached sample data also

Re: Limitting Legends in chart

Anonymous — Tue, 21 Jul 2015 15:19:28 GMT

hi Gautham,

Do below script and get the month end date field in the script and then use that field in the chart. Please see below script and attached QVW file.

left join(Data)

LOAD

DateField,

MonthEnd (DateField) as Monthend_Date

Resident Data;

Re: Limitting Legends in chart

Anonymous — Tue, 21 Jul 2015 19:55:30 GMT

hi Guatham does that help you

Re: Limitting Legends in chart

gauthamchilled — Wed, 22 Jul 2015 01:39:41 GMT

Vinay,

I know how to show only monthend data in the chart. What I want is I want to show all the data for example..

if I am showing 3 months data..the chart must contain data from 1 st jan,2nd jan...till Mar 31st jan.. But visually I don't want to show all these dates in chart legend...I want to restrict the legend...so the legend should be 31st jan, 28th feb, and 31st march..