topic Re: help on Dynamic X axis for Trellis chart in Qlik Learning Discussions

help on Dynamic X axis for Trellis chart

kamakshisuram — Thu, 09 Oct 2014 06:13:35 GMT

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

Re: help on Dynamic X axis for Trellis chart

senarath — Thu, 09 Oct 2014 06:23:21 GMT

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

Re: help on Dynamic X axis for Trellis chart

kamakshisuram — Thu, 09 Oct 2014 06:27:53 GMT

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_Count	month_His	Year_his
2364	October	2014
3674	September	2014
4662	August	2014
5572	July	2014
5747	June	2014
6150	May	2014
6048	April	2014
5082	March	2014
4845	February	2014
4860	January	2014
4868	December	2013
3435	November	2013

Re: help on Dynamic X axis for Trellis chart

senarath — Thu, 09 Oct 2014 08:24:53 GMT

Hi,

At the script create e month year like

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

thanx

Re: help on Dynamic X axis for Trellis chart

kamakshisuram — Thu, 09 Oct 2014 10:47:11 GMT

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