Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everyone,
i want to exclude particular sheets from applying particular filter. For instance, in my sheet i have 4 objects and 4 filters and one filter from those should not apply to those sheets and all other filters need to apply.
How to restrict that.
Do the following to enable and set alternate states:
Now the QlikView developer can create new Alternate States from within screen objects. End-users who access QlikView documents from a QlikView Server can make use of Alternate States but cannot create Alternate States.
Do the following to assign a state to an object:
The object will now be independent from the rest of the document in terms of selection, unless other objects are set to the same state.
There are two states that are always available; default state and inherited. The default state is the state where most QlikView usage occurs and is represented by $. The QlikView document is always in the default state. Objects can inherit states from higher level objects, such as sheets and containers. This means that states are inherited as such: Document - Sheet - Sheet Objects. The sheets and sheet objects are always in the inherited state unless overridden by the QlikView developer.
A simpler and shorter way would be for you to create another alias for the field and change your object field to the new one.
e.g.
LOAD
name,
name as NME,
etc.....
from...............etc.
Then you just change the unwanted one to NME.