Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you have a sample?
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.