Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

kamakshisuram
Not applicable

help on Dynamic X axis for Trellis chart

Hi All,

Please help me if you know the resoulton of this

I have to display last 12 month values in the chart. for now it is last 3 months of 2013 and 9 months of 2014

When I use trellis in the chart , X axis is displaying for all months. Please find below attachments .

In this i do not want to show jan to Sep months for 2013.

I want chart to be like Trellis1 from below attachment instead of Teellis

4 Replies
senarath
Not applicable

Re: help on Dynamic X axis for Trellis chart

Hi,

Problem could be with the calender. If you just show months, it could be any year. Try to create a Month Year(e.g.Mar-14,Apr-14) and apply to the chart.

thanx

Senarath

kamakshisuram
Not applicable

Re: help on Dynamic X axis for Trellis chart

Thanks for the response.

Data is coming directly coming from data base where Month is hard coded. Not from Calender

Data base Query is having data like below.

history_Countmonth_HisYear_his
2364October2014
3674September2014
4662August2014
5572July2014
5747June2014
6150May2014
6048April2014
5082March2014
4845February2014
4860January2014
4868December2013
3435November2013
senarath
Not applicable

Re: help on Dynamic X axis for Trellis chart

Hi,

At the script create e month year like

Left(month_His,3)&'-'&Right(Year_his,2) as Month_Year.

thanx

kamakshisuram
Not applicable

Re: help on Dynamic X axis for Trellis chart

Thanks for the script. Now i can show to my client that this is possible. Can you please confirm me that the above requirement is not possible in qlikview like Dynamic X - axis and hide if no data

Community Browser