Discussion Board for collaboration on QlikView Layout & Visualizations.
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
Not completely sure what you are trying to do. Do you have a qvw sample you can share?
Try to use expression
Try this, using Select in Field and Select Excluded
I tried your suggestion but I doesn't work.
See enclosed qvw
May be this as your calculated dimension:
=If(not WildMatch(HostName, '*LAB*'), Country&'-'&HostName)
It solves almost everything.
However, when I click on "Lab" I want to see the "LAB" Hostnames
Can this be done?
Can you try now
NOTE: Added a variable action to all your buttons and added a new dimension and made both the dimensions conditional
Atached your QVW with the action on each Text Object.
Here you can see the behavior of all Text Object,
Thank You all