topic Re: Conditional show expression in QlikView

Conditional show expression

Tue, 21 Mar 2017 17:16:02 GMT

Hey guys, have an issue, currently I am showing amount and forecast and I want to show all months for the chart (currently using show all values in dimension month) and I want it to show amount values up to the month selected and for the rest I want to show forecast for the months after the max month selected. Thank you in advance

Re: Conditional show expression

Frank_Hartmann — Tue, 21 Mar 2017 19:00:42 GMT

please share a sample qvw.

that would make it much easier to assist!

Re: Conditional show expression

Wed, 22 Mar 2017 17:53:26 GMT

Attached thank you

Re: Conditional show expression

Frank_Hartmann — Wed, 22 Mar 2017 18:48:23 GMT

try that:

Forecast:

Sum(TOTAL Forecast)

hope this helps

Re: Conditional show expression

Thu, 30 Mar 2017 14:53:27 GMT

no thats not working I am trying

Sum({<posting_date={">=$(=min(posting_date))"},fiscal_year={$(=max(fiscal_year))}>}Forecast)

I want months including selected and greater for the selected fiscal year for forecast. also is there a way to hide the actual from showing if it is showing 0s? as in it is not selected and only show forecast and actual for selected and forecast for every month after selected for the rest of the year.