Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stekol61
Contributor

Exclude combined dimentiones

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

16 Replies

Re: Exclude combined dimentiones

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

t_chetirbok
Valued Contributor

Re: Exclude combined dimentiones

Hi!

Try to use expression

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

agustinbobba
Contributor

Re: Exclude combined dimentiones

Hi Stefan,

Try this, using Select in Field and Select Excluded

Actions.png

Best regards!

Agustin.

stekol61
Contributor

Re: Exclude combined dimentiones

Hi!

I tried your suggestion but I doesn't work.

See enclosed qvw

/Stefan

Re: Exclude combined dimentiones

May be this as your calculated dimension:

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


Capture.PNG

stekol61
Contributor

Re: Exclude combined dimentiones

Hi!

It solves almost everything.

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

Can this be done?

/Stefan

Re: Exclude combined dimentiones

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
Contributor

Re: Exclude combined dimentiones

Hi,

Atached your QVW with the action on each Text Object.

Here you can see the behavior of all Text Object,

2016-03-21_14-12-15.png

stekol61
Contributor

Re: Exclude combined dimentiones

Hi!

Problem solved.

Thank You all

/Stefan

Community Browser