Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Pericator
Contributor III
Contributor III

Trellis doesnt show full TimeRange

Hi,

I am currently using a Trellis Chart to show data with Time and Country as the two Dimensions. Sadly Qlik autofits the Time Range as you can see in the Image below. It just shows 2014 and 2015 instead of going from 2014 - 2018. It also doesnt help out with a x-axis scroll bar, which would help atleast.

Can I fix this somehow?

 

Thanks

Pericator

3 Replies
Anil_Babu_Samineni

Please post sample application.
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
hopkinsc
Partner - Specialist III
Partner - Specialist III

Do you have a sample?

Pericator
Contributor III
Contributor III
Author

Hi,

Thanks for your comments. I can't really pull out a sample from my data model. It is huge and most of it is customer related stuff, which I shouldnt post online.

I got a field in a table with Fees, one wiht date as a timestamp in YYYY-MM-DD-HH-MM-SS, one wiht countries. These three I use in the Trellis, look like this. It works fine, just the Trellis is choosing the wrong Time Span to show.

As you can see in the image, it even sorts United States at 2nd position (its sorted descending by fees). But it doesnt seem to have the second highest fee, because it didnt have back in 2014. But now in 2018 (which it doesnt show) it has.

So any way I can make Trellis to show 2016 until now for example? Maybe with set anaylsis in the dimension? Like (aggr(only({<set analysis>}, metric), metric)?

Or second possibility I see is to enable scroll bar somehow?

hope you can help without sample anyway.