topic Re: Specify Minimum for X-Axis in App Development

Specify Minimum for X-Axis

acbishop2 — Wed, 16 May 2018 19:15:42 GMT

Hello All,

I have a bar graph that displays days between marketing and response. I made the x-axis continuous because I want to show gaps if there are any. Regardless of the filters, I need my graph to start at 0. Here's what my graph looks like without filters:

The problem happens when I use a filter to look at specific marketing methods. For example, in the chart below, responses start coming in after 12 days, therefore setting the x-axis minimum to 12.

Any ideas? As always, I appreciate the help!

Re: Specify Minimum for X-Axis

isingh30 — Wed, 16 May 2018 19:42:57 GMT

Can you share your data or sample application?

Thanks.

Re: Specify Minimum for X-Axis

vvira1316 — Wed, 16 May 2018 19:52:46 GMT

You may want to set Static Min to 0. refer to following link, not exactly same situation but will help in understanding.

Force 0 check box may also help

Data Point Value is not completely visible in a Bar Chart with a Log Scale

Re: Specify Minimum for X-Axis

acbishop2 — Wed, 16 May 2018 20:15:04 GMT

Here's some (very) simplified sample data, as well as a sample app. Notice how when you select certain marketing efforts with the filter, the x-axis minimum changes.

Re: Specify Minimum for X-Axis

acbishop2 — Wed, 16 May 2018 20:16:35 GMT

Thanks for the response, Vijay, but I'm needing help with Qlik Sense, not QlikView. ...unless there is a hidden static min box that I'm just not seeing...

Re: Specify Minimum for X-Axis

acbishop2 — Tue, 22 May 2018 22:46:50 GMT

Ishtdeep,

I still haven't been able to figure this out. Can you take a look at it again? I added the data above.

digvijay‌, you've been able to help me with problems like this before. Is this possible?

Re: Specify Minimum for X-Axis

acbishop2 — Wed, 23 May 2018 20:04:45 GMT

This is what I feared. Thanks for confirming.

Re: Specify Minimum for X-Axis

mikaelsc — Wed, 23 May 2018 20:11:34 GMT

adapt your measure? Count([Marketing Effort])+0*Count({1}[Marketing Effort])

Re: Specify Minimum for X-Axis

acbishop2 — Wed, 23 May 2018 20:19:47 GMT

Mikael,

You're a genius. This definitely works for the problem I posed, but it brings up one more issue: this creates both a static minimum and a static maximum (which I don't want). Is there any way to make it so that the static minimum is set to 0 but the maximum changes depending on the data displayed (affected by the filter chosen)?

Re: Specify Minimum for X-Axis

mikaelsc — Wed, 23 May 2018 20:45:06 GMT

Count([Marketing Effort])+0*Count({1<DeltaDate={"<=$(=max(DeltaDate)) "}>}[Marketing Effort])

(i obviously created the delta date field in the script -- use it as dimension as well... it's cleaner

Re: Specify Minimum for X-Axis

rwunderlich — Wed, 23 May 2018 21:41:16 GMT

Brilliant! I'm going to delete my previous "can't do that" response.

-Rob