topic Re: Exluding data with Action in QlikView

Exluding data with Action

stekol61 — Tue, 28 Nov 2017 12:15:05 GMT

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

Re: Exluding data with Action

m_woolf — Tue, 28 Nov 2017 12:57:16 GMT

Use 2 actions:

the first selects nodes that contains LAB

the second is Select Excluded

Re: Exluding data with Action

stekol61 — Tue, 28 Nov 2017 13:05:27 GMT

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?

Re: Exluding data with Action

m_woolf — Tue, 28 Nov 2017 13:11:31 GMT

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

Re: Exluding data with Action

stekol61 — Tue, 28 Nov 2017 13:16:10 GMT

I will try this.

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

Re: Exluding data with Action

m_woolf — Tue, 28 Nov 2017 13:23:25 GMT

For both actions

Re: Exluding data with Action

stekol61 — Tue, 28 Nov 2017 13:32:22 GMT

So:

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

The second Action Select Excluded 'NodeName' ?

Re: Exluding data with Action

jonathandienst — Tue, 28 Nov 2017 13:37:39 GMT

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))

Re: Exluding data with Action

m_woolf — Tue, 28 Nov 2017 13:41:09 GMT

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