topic Re: Hidding Multiple Values in QlikView https://community.qlik.com/t5/QlikView/Hidding-Multiple-Values/m-p/917944#M652021 <HTML><HEAD></HEAD><BODY><P>You want to do this in the chart or the script? How do your expressions look like?</P><P></P><P>Mayb it's enough to filter Forecast expression like</P><P></P><P>=if("ActualExpression"&gt;0, YourForecastExpression)</P></BODY></HTML> Mon, 10 Aug 2015 17:59:21 GMT swuehl 2015-08-10T17:59:21Z Hidding Multiple Values https://community.qlik.com/t5/QlikView/Hidding-Multiple-Values/m-p/917943#M652020 <HTML><HEAD></HEAD><BODY><P>Some of my data has two values displayed when I filter on a month-by-month basis. I'm tracking both Actuals and Forecasts, thus for months that have already occurred, Actuals and Forecasts are displayed simultaneously. How can I hide Forecasts if and only if values are present within Actuals?<IMG alt="data error.png" class="jive-image image-1" src="/legacyfs/online/95569_data error.png" style="width: 620px; height: 198px; margin-right: auto; margin-left: auto; display: block;" /></P></BODY></HTML> Mon, 10 Aug 2015 17:53:20 GMT https://community.qlik.com/t5/QlikView/Hidding-Multiple-Values/m-p/917943#M652020 2015-08-10T17:53:20Z Re: Hidding Multiple Values https://community.qlik.com/t5/QlikView/Hidding-Multiple-Values/m-p/917944#M652021 <HTML><HEAD></HEAD><BODY><P>You want to do this in the chart or the script? How do your expressions look like?</P><P></P><P>Mayb it's enough to filter Forecast expression like</P><P></P><P>=if("ActualExpression"&gt;0, YourForecastExpression)</P></BODY></HTML> Mon, 10 Aug 2015 17:59:21 GMT https://community.qlik.com/t5/QlikView/Hidding-Multiple-Values/m-p/917944#M652021 swuehl 2015-08-10T17:59:21Z Re: Hidding Multiple Values https://community.qlik.com/t5/QlikView/Hidding-Multiple-Values/m-p/917945#M652022 <HTML><HEAD></HEAD><BODY><P>PERFECT!</P></BODY></HTML> Mon, 10 Aug 2015 18:01:53 GMT https://community.qlik.com/t5/QlikView/Hidding-Multiple-Values/m-p/917945#M652022 2015-08-10T18:01:53Z