topic Re: Transform date inside graph in QlikView

Transform date inside graph

Thu, 20 Dec 2012 11:43:05 GMT

Hi Qlikview community,

I have created a line graph as depicted in the attached image below.

The problem is that my dimention has a format like 2012-1,2012-2,.....2013-1,2013-2...e.t.c

Is there any way to tranform my format in something like 2012-Jan,2012-Feb but to do the tranformation inside the graph????

I have already tried =SubField(b.TestMonthYear,'-',1)&'-'& if(SubField(b.TestMonthYear,'-',2)=1,'Jan','Feb')...etc inside dimemntion text format but it works for 2 months only althought i believe it should be able to do it for every month but nested if does not work.

Any help appreciated.

Re: Transform date inside graph

Gysbert_Wassenaar — Thu, 20 Dec 2012 11:48:49 GMT

You could try this:

=SubField(b.TestMonthYear,'-',1)&'-'& pick(SubField(b.TestMonthYear,'-',2),'Jan','Feb','Mar','Apr','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

But perhaps you should split that field in the script so you have a year and a month field for use in the chart.

Re: Transform date inside graph

Thu, 20 Dec 2012 12:01:49 GMT

Thanks for your time Gysbert it works like a treat...Just add the May in months to get the totally correct expression.
I know that i should do in within the script but i want to learn to do it on the fly to...:)