topic Re: Dimension in Bar Chart in QlikView

Dimension in Bar Chart

krishna20 — Wed, 13 Aug 2014 08:41:53 GMT

Hi Community,

I need to display month and year at X-Axis in Bar Chart, for last three years.Eg;Jan-2012....Dec-2012 .I need to take Calculated Dimension.Having Field as TP_APPR_DT in numeric format.

Please anyone suggest me how to solve it.

Thanks & Regards

Krishna

Re: Dimension in Bar Chart

ashfaq_haseeb — Wed, 13 Aug 2014 09:03:58 GMT

Hi,

Can you attach sample data with expected output.

Regards

ASHFAQ

Re: Re: Dimension in Bar Chart

krishna20 — Wed, 13 Aug 2014 09:40:04 GMT

Dear Mohammed,

Please find the attachments,and guide me how to solve it.

Regards

Krishna

Re: Dimension in Bar Chart

kaushiknsolanki — Wed, 13 Aug 2014 09:44:25 GMT

Hi,

Use dimension as Floor(TP_APPR_DT )

Regards,

Kaushik Solanki

Re: Dimension in Bar Chart

avinashelite — Wed, 13 Aug 2014 09:56:44 GMT

Hi Kalyan,

Try like this

=if(year(TP_MonthYear)>='2012',Date(TP_MonthYear,'MMM-YYYY'))

=if(year(TP_MonthYear)>='2012',MonthName(TP_MonthYear)) and check the suppress null.

please find the attachment for the same

Re: Dimension in Bar Chart

er_mohit — Wed, 13 Aug 2014 10:01:26 GMT

Try this instead of if condition

Monthname(TP_MonthYear)

Re: Re: Dimension in Bar Chart

krishna20 — Wed, 13 Aug 2014 10:14:52 GMT

Thank You Avinash

Regards

Krishna

Re: Dimension in Bar Chart

avinashelite — Wed, 13 Aug 2014 10:15:58 GMT