Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
fikristar
Creator
Creator

filter data and chart

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!

1 Solution

Accepted Solutions
sunny_talwar

Try this:

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

View solution in original post

5 Replies
sunny_talwar

Try this:

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

briancopple
Creator II
Creator II

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

fikristar
Creator
Creator
Author

Thanks, Sunny.

Apparently this is so simple!

fikristar
Creator
Creator
Author

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