topic Re: displaying a chart/kpi if a filter is selected in App Development

displaying a chart/kpi if a filter is selected

jerryr125 — Mon, 10 Jun 2019 18:53:49 GMT

Hi -

Is there a way to NOT display a chart or KPI unless a date is selected in the filter criteria ?

Therefore, IF GetFieldSelections (DATE) is null, can you somehow not display a specific chart??

Thanks - Jerry

Re: displaying a chart/kpi if a filter is selected

dplr-rn — Mon, 10 Jun 2019 19:00:13 GMT

Which version of sense are you on. Latest versions comes with dashboard bundle which has a extension called show hide container . That should suit your need.
its available outside the bundle below
https://developer.qlik.com/garden/583764c83dc0cfc4138afa26

Re: displaying a chart/kpi if a filter is selected

jerryr125 — Mon, 10 Jun 2019 19:26:28 GMT

Hi - thanks for your response. That feature only lets me select certain visualizations though.

Any other thoughts ? Jerry

Re: displaying a chart/kpi if a filter is selected

jerryr125 — Mon, 10 Jun 2019 19:35:17 GMT

I tried this - no luck:

IF (GetFieldSeleactions (DATE) isnull(), 0, AMOUNT)

thoughts ? Jerry

Re: displaying a chart/kpi if a filter is selected

dplr-rn — Mon, 10 Jun 2019 19:58:50 GMT

not sure about the restrictions. but
try if(GetSelectedCount(Date)=0, 0, AMOUNT)

Re: displaying a chart/kpi if a filter is selected

jerryr125 — Mon, 10 Jun 2019 20:32:43 GMT

if( IsNull(GetFieldSelections(DATE)), 0, AMOUNT)

this did the trick ! Thanks - Jerry

Re: displaying a chart/kpi if a filter is selected

shelliM — Wed, 08 Feb 2023 17:11:42 GMT

I was able to make this work in my App, but some of the months (that have data available) still show a 0, any thoughts on that?

if( IsNull(GetFieldSelections(DATE)), 0, AMOUNT)