Exclude combined dimentiones

[stekol61]

Hi!

I have created a pivot table that uses a combined dimension as header.

The combined dimension is =Country&'-'&HostName.

I use Text Object "boxes" to select between different Countries (Action -> Select in Field).

For each Country there are HostName' like "LAB*".

How can I exclude them from the table?

I have a Text Object "boxe" (Lab) that only should contain the "LAB*" Hosts.

See enclosed example

/Stefan

[sunny_talwar]

Not completely sure what you are trying to do. Do you have a qvw sample you can share?

[t_chetirbok]

Hi!

Try to use expression

​sum({<HostName-={"*LAB*"}>} VALUE)

[agustinbobba]

Hi Stefan,

Try this, using Select in Field and Select Excluded

Best regards!

Agustin.

[stekol61]

Hi!

I tried your suggestion but I doesn't work.

See enclosed qvw

/Stefan

[sunny_talwar]

May be this as your calculated dimension:

=If(not WildMatch(HostName, '*LAB*'), Country&'-'&HostName)

[stekol61]

Hi!

It solves almost everything.

However, when I click on "Lab" I want to see the "LAB" Hostnames

Can this be done?

/Stefan

[sunny_talwar]

Can you try now

NOTE: Added a variable action to all your buttons and added a new dimension and made both the dimensions conditional

[agustinbobba]

Hi,

Atached your QVW with the action on each Text Object.

Here you can see the behavior of all Text Object,

[stekol61]

Hi!

Problem solved.

Thank You all

/Stefan