Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

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
sunny_talwar

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

t_chetirbok
Creator III
Creator III

Hi!

Try to use expression

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

agustinbobba
Partner - Creator
Partner - Creator

Hi Stefan,

Try this, using Select in Field and Select Excluded

Actions.png

Best regards!

Agustin.

stekol61
Creator
Creator
Author

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)


Capture.PNG

stekol61
Creator
Creator
Author

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
Partner - Creator
Partner - Creator

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
Creator
Creator
Author

Hi!

Problem solved.

Thank You all

/Stefan