Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar chart with Interval

Hi

 

ALT_TIMEACT_TIMEMAR
1:001:00ABC1234
2:154:40ABC1235
13:1514:15ABC1236
14:4515:15ABC1237
21:0522:05ABC1238

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

6 Replies
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
Partner - Creator II
Partner - Creator II

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

Not applicable
Author

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

Not applicable
Author

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