Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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