Bar chart with Interval

[#1]

Hi

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

[Kushal_Chawda]

Hi,

I think you have already created the same thread before

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

Please close that thread

[prashantbaste]

Hi

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

[#4]

Hi..

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

[Kushal_Chawda]

Please close that thread with helpful or correct answer

[Kushal_Chawda]

Please see the attached

[#7]

Hi

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