topic Re: Bar chart with Interval in QlikView

Bar chart with Interval

Fri, 17 Jul 2015 06:44:29 GMT

ALT_TIME	ACT_TIME	MAR
1:00	1:00	ABC1234
2:15	4:40	ABC1235
13:15	14:15	ABC1236
14:45	15:15	ABC1237
21:05	22:05	ABC1238

Need to create a BAR chart with Interval as Dimension and Count of MAR Based on ALT_TIME and ACT_TIME in the same graph.

Attaching the graph in excel

Re: Bar chart with Interval

Kushal_Chawda — Fri, 17 Jul 2015 06:52:08 GMT

Hi,

I think you have already created the same thread before

https://community.qlik.com/thread/172855?sr=stream

Please close that thread

Re: Bar chart with Interval

prashantbaste — Fri, 17 Jul 2015 06:54:06 GMT

In dimensions use calculated dimension as ALT_TIME&' - '&ACT_TIME

in expressions write Count(MARS)

You will get desired output.

Hope this will be helpful for you.

Regards,

Prashant P Baste

Re: Bar chart with Interval

Fri, 17 Jul 2015 06:54:25 GMT

Hi..

that was with 2 Tables. Now the requirement is it has to taken from 1 table

Re: Bar chart with Interval

Kushal_Chawda — Fri, 17 Jul 2015 06:57:49 GMT

Please close that thread with helpful or correct answer

Re: Bar chart with Interval

Kushal_Chawda — Fri, 17 Jul 2015 07:05:19 GMT

Please see the attached

Re: Bar chart with Interval

Thu, 23 Jul 2015 09:01:51 GMT

Thanks for the reply.

The problem here for me is i have a very large dataset , Around 5 GB of Data. It may impact my perfomance a lot i guess. is there any other alternative