Specify Minimum for X-Axis

[acbishop2]

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!

[isingh30]

Can you share your data or sample application?

Thanks.

[vvira1316]

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

[acbishop2]

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.

[acbishop2]

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...

[acbishop2]

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?

[acbishop2]

This is what I feared. Thanks for confirming.

[mikaelsc]

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

[acbishop2]

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)?

[mikaelsc · Accepted solution]

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