topic Re: custom x-axis, script or calculated dimension? in QlikView

custom x-axis, script or calculated dimension?

Thu, 12 Jul 2012 16:05:58 GMT

Hi, I'm looking to create a custom axis for my chart and was wondering if anyone has any ideas?

Basically the x-axis should show Q1, Q2, Q3, Q4 of last year, and at the end of the axis it should also have the month selected of this year. I'm really not sure how to go about this. Any help would be much appreciated.

thanks in advance

Re: custom x-axis, script or calculated dimension?

Thu, 12 Jul 2012 16:17:33 GMT

it is a pretty freak:P idea but:

makew an iland table :

LOAD * INLINE [

dimension

actualmonth

];

paste dimension as your dimension and make an expression such as: if (dimension =q1, "set analysis", if(....))

Re: custom x-axis, script or calculated dimension?

Thu, 12 Jul 2012 16:28:40 GMT

Hi,

If the yaxis is sales (say in a bar chart), you can create 5 expressions with setanalysis. Name the expressions as Q1,Q2,..,CurrentMonth

That would do it.

Kiran.