Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Exluding data with Action

Hi!

This is related to my earlier question "Exluding data in script".

What I need is an Action in the 'Warning & Uptime' button that excludes nodes that contain the name 'LAB'.

How can this be done?

/Stefan

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

stefan kollberg wrote:

The nodename is a dimention: Country&'-'&Hostname. Maybe that's why it doesn't work.

I assume that the "LAB" is in the hostname. So apply the logic outlined above to Hostname (select *LAB* (Hostname) and then select excluded (Hostname))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

8 Replies
m_woolf
Master II
Master II

Use 2 actions:

the first selects nodes that contains LAB

the second is Select Excluded

stekol61
Creator
Creator
Author

It doesnt work.

The nodename is a dimention: Country&'-'&Hostname. Maybe that's why it doesn't work.

Regarding ''Select Excluded' whet field should be excluded?

m_woolf
Master II
Master II

I suggest that you create a field in script, something like:

Country & '-' & Hostname as NodeName,


Then Use NodeName in your chart and as the Field for the Actions

stekol61
Creator
Creator
Author

I will try this.

Should i then use the action ''Select Excluded' for this new 'NodeName'?

m_woolf
Master II
Master II

For both actions

stekol61
Creator
Creator
Author

So:

The first Action selects NodeName that contains LAB (='*LAB*')

The second Action Select Excluded 'NodeName' ?

jonathandienst
Partner - Champion III
Partner - Champion III

stefan kollberg wrote:

The nodename is a dimention: Country&'-'&Hostname. Maybe that's why it doesn't work.

I assume that the "LAB" is in the hostname. So apply the logic outlined above to Hostname (select *LAB* (Hostname) and then select excluded (Hostname))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
m_woolf
Master II
Master II

Yes - or use Jonathan's suggestion and Use Hostname for both actions