topic Re: Chart dimensions not filtering in QlikView

Chart dimensions not filtering

cbaqir — Wed, 14 Sep 2016 17:49:58 GMT

If you select FY16 and a PROG_PORT selection (first column in both tables), the charts are not reflecting only the rows in that selection. Not sure what is wrong but it didn't used to do this.

Re: Chart dimensions not filtering

swuehl — Wed, 14 Sep 2016 18:02:33 GMT

I currently can't open your QVW.

Are you maybe using set analysis in your expressions that are preventing the dimension to filter?

Re: Chart dimensions not filtering

sunny_talwar — Wed, 14 Sep 2016 18:04:46 GMT

Check now

Re: Chart dimensions not filtering

cbaqir — Wed, 14 Sep 2016 18:38:44 GMT

What did you do?

Re: Chart dimensions not filtering

sunny_talwar — Wed, 14 Sep 2016 18:41:25 GMT

Multiplied your 2nd and 3rd expression by Avg(1)

Re: Chart dimensions not filtering

cbaqir — Wed, 14 Sep 2016 19:56:07 GMT

Why?

Re: Chart dimensions not filtering

sunny_talwar — Wed, 14 Sep 2016 20:02:49 GMT

There might be set analysis to ignore selections, I did not look very closely, but I know that Avg(1) will equal to 1 for your selection and will equal to 0 outside the selection making those values go away which you are seeing right now. Is this not what you want or are you looking to do this in a better way?

Re: Chart dimensions not filtering

sunny_talwar — Wed, 14 Sep 2016 20:09:41 GMT

Or do this:

=if(GetSelectedCount(FISCAL_YEAR)=0,0,If(Max({<IS_CUR_FCST = {'y'}>}APP_DATE) < Max({1<IS_CUR_FCST = {'y'}>}FCST_DATE)+1, 0,

Round(Sum({1<FCST_DATE = {"$(=Date(Max({<IS_CUR_FCST = {'y'}>}FCST_DATE), 'MM-DD-YYYY'))"}, IS_CUR_FCST = {'y'}, REQUEST_ID = $::REQUEST_ID, REQ_ID_NAME = $::REQ_ID_NAME, PROG_PORT = $:: PROG_PORT>} FCST_AMT), 1000)/1000))

Re: Chart dimensions not filtering

sunny_talwar — Wed, 14 Sep 2016 20:11:36 GMT

I think the use of 1 here is restricting your selections and that's why we saw all the rows even when you selected a single PROG_PORT

Re: Chart dimensions not filtering

cbaqir — Wed, 14 Sep 2016 20:13:56 GMT

I just have to make sure that doesn't affect the expression result.

Re: Chart dimensions not filtering

sunny_talwar — Wed, 14 Sep 2016 23:28:14 GMT

Sounds good

Re: Chart dimensions not filtering

cbaqir — Thu, 15 Sep 2016 16:56:41 GMT

In my sample, I had disabled the Status expressions. In my actual file, with these enabled in the Program level graph, the filer on Program doesn't work. If I add the *avg(1) for all status fields, the filter works but the status fields are no longer displayed since their values are not numeric. Thoughts?

Scope Status:

=(if([CUR_PROG_SCOPE_HEALTH] = 'Green' , 'qmem://<bundled>/BuiltIn/check_g.png'

,if([CUR_PROG_SCOPE_HEALTH] = 'Yellow', 'qmem://<bundled>/BuiltIn/exclamation_y.png'

,if([CUR_PROG_SCOPE_HEALTH] = 'Red', 'qmem://<bundled>/BuiltIn/cross_r.png'

, 'qmem://<bundled>/BuiltIn/minus.png'

))))*avg(1)

Re: Chart dimensions not filtering

sunny_talwar — Thu, 15 Sep 2016 17:00:33 GMT

Use an if statement

If(Column(1) > 0,

=(if([CUR_PROG_SCOPE_HEALTH] = 'Green' , 'qmem://<bundled>/BuiltIn/check_g.png'

,if([CUR_PROG_SCOPE_HEALTH] = 'Yellow', 'qmem://<bundled>/BuiltIn/exclamation_y.png'

,if([CUR_PROG_SCOPE_HEALTH] = 'Red', 'qmem://<bundled>/BuiltIn/cross_r.png'

, 'qmem://<bundled>/BuiltIn/minus.png'

)))))

Where you check in another column if that column is greater than 0 or not.

Re: Chart dimensions not filtering

cbaqir — Thu, 15 Sep 2016 17:20:33 GMT

Thank you so much!