Limitting Legends in chart

[gauthamchilled]

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?

[krishna20]

Hi Gautham,

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

[help4qv123]

Share a sample so that we can help you

[gauthamchilled]

attached sample..

[help4qv123]

=monthend(DateField)

Try this expression in Your chart dimension.

[gauthamchilled]

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.

[gauthamchilled]

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?

[qlikviewwizard]

Hi gauthamchilled

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

[gauthamchilled]

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

[Anonymous]

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;