topic Re: how to plot a bar chart on two fields as one dimension in QlikView

how to plot a bar chart on two fields as one dimension

Fri, 07 Oct 2016 13:29:35 GMT

Hi all

I have a table, with three column as shown below. I would like to plot a bar chart. how much time taken for each row..

I mean..

X-axis should be Date and time

Y-axis should be time-taken

Thanks

sunny_talwar — Fri, 07 Oct 2016 13:31:34 GMT

May be use this as your dimension

TimeStamp(DateRan + TimeRan)

Fri, 07 Oct 2016 13:52:11 GMT

I dont know i am getting the following bar chart result

only one value is appearing on the chart

Thanks

sunny_talwar — Fri, 07 Oct 2016 13:55:00 GMT

I think the other values are plotting, but they are very small. Do you have a static max on the axis tab by any chance?

Fri, 07 Oct 2016 13:58:14 GMT

Hi sunny

I dont have anything on the static max

sunny_talwar — Fri, 07 Oct 2016 13:59:32 GMT

Do you have continuous enabled?

Fri, 07 Oct 2016 15:26:19 GMT

Hi sunny,

No . I didnt enable continuous..

But, you are right... the chart is plotting the values when i select the data on different range of dates.

can we put a scroll bar on bar chart to drag and see the full chart

is it possible?

Thank you

sunny_talwar — Fri, 07 Oct 2016 15:28:53 GMT

Sure, try enabling the scroll bar on the presentation tab

Fri, 07 Oct 2016 15:36:09 GMT

Thank you so much sunny

really helpful and learned about bar chart

sunny_talwar — Fri, 07 Oct 2016 15:36:55 GMT

I am glad you did.

Best,

Sunny