topic Re: Exclude combined dimentiones in QlikView

Exclude combined dimentiones

stekol61 — Mon, 21 Mar 2016 11:13:39 GMT

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

Re: Exclude combined dimentiones

sunny_talwar — Mon, 21 Mar 2016 12:05:02 GMT

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

Re: Exclude combined dimentiones

t_chetirbok — Mon, 21 Mar 2016 13:56:06 GMT

Hi!

Try to use expression

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

Re: Exclude combined dimentiones

agustinbobba — Mon, 21 Mar 2016 13:58:43 GMT

Hi Stefan,

Try this, using Select in Field and Select Excluded

Best regards!

Agustin.

Re: Exclude combined dimentiones

stekol61 — Mon, 21 Mar 2016 14:21:37 GMT

Hi!

I tried your suggestion but I doesn't work.

See enclosed qvw

/Stefan

Re: Exclude combined dimentiones

sunny_talwar — Mon, 21 Mar 2016 14:34:09 GMT

May be this as your calculated dimension:

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

Re: Exclude combined dimentiones

stekol61 — Mon, 21 Mar 2016 14:45:05 GMT

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

sunny_talwar — Mon, 21 Mar 2016 16:27:01 GMT

Can you try now

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

Re: Exclude combined dimentiones

agustinbobba — Mon, 21 Mar 2016 17:22:17 GMT

Hi,

Atached your QVW with the action on each Text Object.

Here you can see the behavior of all Text Object,

Re: Exclude combined dimentiones

stekol61 — Tue, 22 Mar 2016 13:22:12 GMT

Hi!

Problem solved.

Thank You all

/Stefan

Re: Exclude combined dimentiones

oknotsen — Tue, 22 Mar 2016 14:38:11 GMT

If your problem is solved, please flag the Correct Answer to "close" the topic.

If not, please let us know what part of this topic you still need help with .

Re: Exclude combined dimentiones

stekol61 — Tue, 22 Mar 2016 14:51:45 GMT

Hi!

How do I do this?

/Stefan

Re: Exclude combined dimentiones

sunny_talwar — Tue, 22 Mar 2016 15:46:03 GMT

Check this out: Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Exclude combined dimentiones

oknotsen — Tue, 22 Mar 2016 19:51:52 GMT

Simply clicking on that green star with the text "Correct Answer" next to it on the post that is the correct answer should do the trick.

My guess is that it is not visible for you, else it would be very obvious.

Re: Exclude combined dimentiones

sunny_talwar — Tue, 22 Mar 2016 19:59:37 GMT

Onno van Knotsenburg‌ - How come it is not available for few people and available for others?

Re: Exclude combined dimentiones

oknotsen — Tue, 22 Mar 2016 20:29:36 GMT

That, my dear Sunny, is a very good question.

I really have no clue. I see them and I am using that not so cool browser called "IE11".

I can only guess:

Probably the (old?) browser or some browser setting they are using.

Re: Exclude combined dimentiones

stekol61 — Wed, 23 Mar 2016 08:12:50 GMT

Hi!

Closed now.

Used Chrome

/Stefan