Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Hidding Multiple Values

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?data error.png

1 Solution

Accepted Solutions
MVP
MVP

Re: Hidding Multiple Values

You want to do this in the chart or the script? How do your expressions look like?

Mayb it's enough to filter Forecast expression like

=if("ActualExpression">0, YourForecastExpression)

2 Replies
MVP
MVP

Re: Hidding Multiple Values

You want to do this in the chart or the script? How do your expressions look like?

Mayb it's enough to filter Forecast expression like

=if("ActualExpression">0, YourForecastExpression)

Not applicable

Re: Hidding Multiple Values

PERFECT!

Community Browser