Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Maximize ROI with Qlik Professional Services – Expert Guidance, Faster Results: Explore Qlik Services
cancel
Showing results for 
Search instead for 
Did you mean: 
s2016
Contributor III
Contributor III

Line chart formatting

I have fields such as "date", "timeslot", "inbound", "outbound" in my data set.

I want to use this dataset to plot a daily trend but it should show the values at timeslot level without aggregating it to the daily level.

My graph should look something like the attached "Expected_Chart".

PS: I would be using 14 dates in my chart and for each date there are 48 timeslots.

I am currently concatenating the "date" and "timeslot" fields into a single field called "date_ts" and then using this as my dimension to plot the values. My challenge is to display specific "dates" in the x-axis rather than "date_ts".

If that is not possible, I would like to squeeze my chart to show alteast 7 days of data.

Please let me know if my approach is correct and how I can format my chart to get the desired results.  

1 Solution

Accepted Solutions
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Maybe you can change the graph type to bars chart.

Like attached example.

Cheers,

View solution in original post

9 Replies
prma7799
Master III
Master III

Please share some sample app.

Anil_Babu_Samineni

We have till this control only. And that if data is good then it may work

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
RonaldDoes
Partner - Creator III
Partner - Creator III

You could Date(Floor(Timestamp)) AS Date_chart and use that as a dimension for your chart, right?

avinashelite

What do you mean by specific Date ? you other chart is showing according to days not the date !!

change the dates to common format that should resolve the issue

s2016
Contributor III
Contributor III
Author

I do not have a Date Timestamp. Just Date (e.g. 20170101) and Timeslot (e.g. 1, 2, 3,.....48). For each Date there are 48 Timeslots.  

I basically want to plot data for each Timeslot of every Date but want just "Date" values to be displayed on x-axis.

eg) Rather than displaying 20170101_1, 20170101_2, ...................20170101_48,  ........ 20170114_1, .....20170114_48,  I want to display just the dates i.e) 20170101, 20170102.....20170114.

s2016
Contributor III
Contributor III
Author

Thats fine Avinash. I need not display the days necessarily. I am more interested in dates and I am not sure how formatting the date would resolve this.

Just to be clear, my "Date" and "Timeslot" are different fields. 

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Maybe you can change the graph type to bars chart.

Like attached example.

Cheers,

s2016
Contributor III
Contributor III
Author

Hi Federico,

I think you forgot to attach the file.

Thanks

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

I can see the attached file...TEST_dates.qvw