topic Re: How do you filter chart data by a field in a List box. in QlikView

How do you filter chart data by a field in a List box.

Mon, 21 Nov 2016 10:09:14 GMT

Hello and thank you for reading this.

I am new to QlikView and would like to know how I use a selection item in a List Box to filter data I have in a Chart.

In my Script I have loaded in a single Filter dimension

DimensionsForFilter:

LOAD

INLINE [

FilterDimensions

'Project Is Active'

];

Then I have a List Box that has the 'Project Is Active' from the FilterDimensions.

I have a chart that has a LED presented field of 'Project is Active' that is showing its value of 'Yes' or 'No', but i would like to only show result lines for those items with a value of 'Yes' if the FilterDimensions selection 'Project Is Active' is clicked and activated.

Man Thanks

Re: How do you filter chart data by a field in a List box.

Anonymous — Mon, 21 Nov 2016 11:06:49 GMT

Can you send a sample qvw file?

Re: How do you filter chart data by a field in a List box.

Mon, 21 Nov 2016 11:31:52 GMT

I have attached, but i do use a SQL DB to populate chart

Thanks

Re: How do you filter chart data by a field in a List box.

Anonymous — Mon, 21 Nov 2016 12:03:46 GMT

See if this is

Re: How do you filter chart data by a field in a List box.

Mon, 28 Nov 2016 08:20:33 GMT

Thanks for the update, however I am awaiting for Qlik to get back to me as I need a license to use your response, will let you know as they seem a bit slow on responding.

Re: How do you filter chart data by a field in a List box.

Mon, 28 Nov 2016 13:37:43 GMT

I can see that you added a different condition to each field

=if(not IsNull(GetFieldSelections(FilterDimensions)) and [Project Is Active] = 'Yes', [Project Code], if(IsNull(GetFieldSelections(FilterDimensions)) and [Project Is Active] = 'No', [Project Code]))

But does not seem to work.

Re: How do you filter chart data by a field in a List box.

Mon, 12 Dec 2016 10:26:23 GMT

Hi, I finally have a fully activated QlikView and your copy of the file worked fine and I can see how you now do the filtering.

Thanks for your help, sorry it took so long for me to actually use it, dam import restriction.

Re: How do you filter chart data by a field in a List box.

Anonymous — Mon, 12 Dec 2016 10:31:14 GMT

You're welcome. I hope it helped you.