topic Re: filter data and chart in QlikView

filter data and chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Still learning Qlikview after a few weeks...

I have data with a filed/column that contains some strings indicating the status of the system; in network with additional information after this word, out of network with additional information or undetected with additional information/string after this word. I need to filter the chart showing the information when this field only shows in-network and discard the counts when this filed shows different value.

Tried to filter with set analysis but could not find a way to filter only partial value from the string.

I'd prefer not to filter it when loading since other values in the column may be used for other purposes.

What would be the easiest way to do this?

Appreciate any help.

Thank you!

Re: filter data and chart

sunny_talwar — Wed, 01 Jun 2016 15:54:53 GMT

Try this:

Count({<FieldA = {'in-network*'}>}FieldB)

Re: filter data and chart

Anonymous — Wed, 01 Jun 2016 16:02:05 GMT

Could you use a function like subfield in your script to create a new field and use this in your chart?

Kindest Regards

Brian

Re: filter data and chart

Anonymous — Wed, 01 Jun 2016 16:45:19 GMT

Thanks, Sunny.

Apparently this is so simple!

Re: filter data and chart

Anonymous — Wed, 01 Jun 2016 16:53:43 GMT

Hi Brian,

Set analysis suggested by Sunny works, but could you elaborate your

alternative way? Are you suggesting to filter it in the load script?

Thanks,

Fikri

Re: filter data and chart

sunny_talwar — Wed, 01 Jun 2016 16:58:19 GMT

Please close the thread by marking correct answer if the issue is resolved

Qlik Community Tip: Marking Replies as Correct or Helpful‌

Best,

Sunny