Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Can you share your data or sample application?
Thanks.
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
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.
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...
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?
This is what I feared. Thanks for confirming.
adapt your measure? Count([Marketing Effort])+0*Count({1}[Marketing Effort])
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)?
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