topic Re: X axis dimension filter in QlikView

X axis dimension filter

Tue, 27 Sep 2016 20:59:49 GMT

Hi all,

The above chart's x dimension has serial numbers and the chart is sorted by the start line date which goes into november 2016. I only want to see the 15 serials that are most recent based on the start line date. They are showing above, but I want to get rid of the scroll bar because the y axis sometimes gets messed up since some of the previous serial numbers have higher values than the 15 displayed. If i could get rid of that scroll bar, the highest y axis would be about 30. I can't use the static max / min because the numbers change so often drastically.

Re: X axis dimension filter

sunny_talwar — Tue, 27 Sep 2016 21:11:16 GMT

May be use set analysis or calculated dimension to show a certain range?

Re: X axis dimension filter

robert_mika — Tue, 27 Sep 2016 21:13:48 GMT

I believe you can turn off the scrolling in Presentation Chart Scrolling options.

Or use the Dimension Limits (second tab from the beginning)

Re: X axis dimension filter

Tue, 27 Sep 2016 21:14:09 GMT

I agree, but how? I've tried using set analysis but I can't figure out how to do it since the dates are later than today's date, and also always changing.

Re: X axis dimension filter

Tue, 27 Sep 2016 21:15:35 GMT

You can, but I need to see the last 15 only. If I turn off the scrolling I see everything, which I do not want.

Re: X axis dimension filter

sunny_talwar — Tue, 27 Sep 2016 21:16:58 GMT

Not sure how the data is, but may be

{<Date = {"$(='>=' & Max(Date) - 15 & '<=' & Max(Date))"}>}

Re: X axis dimension filter

Tue, 27 Sep 2016 21:24:13 GMT

I tried this:

sum({<START_LINE_DT = {"$(='>=' & Max(START_LINE_DT) - 50 & '<=' & Max(START_LINE_DT))"}>} REJECT_QTY)

and it says no data to display

Re: X axis dimension filter

sunny_talwar — Wed, 28 Sep 2016 00:55:59 GMT

How is START_LINE_DT formatted? Like a date or a number? If it is date, may be try this

Sum({<START_LINE_DT = {"$(='>=' & Date(Max(START_LINE_DT) - 50, 'DateFieldFormatHere') & '<=' & Date(Max(START_LINE_DT), 'DateFieldFormatHere'))"}>} REJECT_QTY)