filter data and chart

[Anonymous]

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!

[sunny_talwar · Accepted solution]

Try this:

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

[Anonymous]

Hi

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

Kindest Regards

Brian

[Anonymous]

Thanks, Sunny.

Apparently this is so simple!

[Anonymous]

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

[sunny_talwar]

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

Qlik Community Tip: Marking Replies as Correct or Helpful‌

Best,

Sunny