topic Bar Chart X Axis Values in QlikView

Bar Chart X Axis Values

MK_QSL — Wed, 21 May 2014 14:16:17 GMT

Please check enclosed file showing Trellis Bar Chart.

What I want is to show Bar Chart X - Axis Timing as 10:00, 11:00, 12:00 without changing the size of bar chart.

The Bar corresponding to 10:15, 10:30, 10:45 etc should be there but only bar chart should not show the name.

Hope my requirement is clear...

Re: Bar Chart X Axis Values

arthur_dom — Wed, 21 May 2014 17:53:50 GMT

It's that( attached file) ?

I used this expression:

time#(text(if(Customer = 'X' , time(Time#(Time,'hh:mm'),'hh:00'), Time#(Time,'hh:mm') )),'hh:mm') as Time

Re: Bar Chart X Axis Values

MK_QSL — Thu, 22 May 2014 05:45:16 GMT

Dear Arthur,

Thanks for your reply.

Looks like you misunderstood the question.

I want all bar but the axis should only show full Hour ... i.e. 10:00 11:00 12:00

Re: Re: Bar Chart X Axis Values

crusader_ — Thu, 22 May 2014 05:57:05 GMT

Hi Manish,

PFA qvw file.

Hope I understood you correctly if not please reply.

Andrei

Re: Bar Chart X Axis Values

tresB — Thu, 22 May 2014 07:05:52 GMT

Create a new field, like:

Dual(Time(Time#(Time,'hh:mm'),'hh'),Time#(Time,'hh:mm')) as Hour,

And use that as dimension. See attachment.

Re: Bar Chart X Axis Values

MK_QSL — Thu, 22 May 2014 08:38:30 GMT

Looks better and yes, you completely understood my requirement but can't we do it without using Continuous and Static Step in Axes Tab?

Re: Bar Chart X Axis Values

tresB — Thu, 22 May 2014 08:42:50 GMT

Have a look at the attachment I tried.

Re: Bar Chart X Axis Values

MK_QSL — Thu, 22 May 2014 08:49:17 GMT

Yes but this is not I am looking for... Thanks for your suggestion Tresesco

Re: Bar Chart X Axis Values

crusader_ — Thu, 22 May 2014 09:22:38 GMT

Hm... Let me think.

You can try to mix some approaches.

Look this thread

Dimension Text type in a barchart

I like giakoum

solution, then in your case you just change Text Color to White() in 15, 30, 45 minutes and Black() in 00 minutes.

I hope this helps.

Andrei

Re: Re: Bar Chart X Axis Values

tresB — Thu, 22 May 2014 09:37:25 GMT

May be like this?

Re: Bar Chart X Axis Values

rwunderlich — Sun, 25 May 2014 19:19:47 GMT

Treseco is on the right track, but I would use a calculated Dim like:

=dual(if(Minute(Time)=0, Time, ''), Time)

That will display blank on the axis unless it's the top of the hour.

-Rob

http://masterssummit.com

http://robwunderlich.com