topic Re: How to display Year Month Label at X Axis ? in QlikView

How to display Year Month Label at X Axis ?

paulyeo11 — Mon, 15 Apr 2013 14:21:34 GMT

Hi All

My Stock Balance amount by month are make use of addmonths command. and when i convert the table to chart , it is possible for me to display YearMonth label on X Axis ?

https://www.dropbox.com/s/wy5e6n4c8mg69xj/QV4FS_ver304%20ver%20003.qvw

Above link you can download my QV Doc.

Paul

Re: How to display Year Month Label at X Axis ?

kaushiknsolanki — Mon, 15 Apr 2013 17:58:53 GMT

Hi,

All you need to do is, remove the dimension keep it blank.

Click on each of the expression and uncheck "Expression as Legend"

Also go to presentation tab and uncheck "show legend"

Have a look at the attachment.

Regards,

Kaushik Solanki

Re: How to display Year Month Label at X Axis ?

paulyeo11 — Tue, 16 Apr 2013 04:56:48 GMT

Hi Kaushik

Thank you veyr much for your advise , now i know i am able to plot the bar chart by period. since my actual data have stock value since 1996. and i am aware that it is no point to analysis which are more then 17 year ago, but for my interest only , do you aware that it there any short cut which i can plot the chart using one expression ? ( as i convert the table to chart , that is why i need each expression for each bar ).

Hope you can advise me , i will accept your advise as final. So your advise will be appreciated very much.

Paul