Filters and Expressions

[suvechha_b]

• Phases -Selection criteria to include “All Open” and “All Closed” – All Open to include all phases excluding - “controlled closure”, “Cancelled”, “awaiting ITR”, “Demand requested” and “Pending classification”. All closed to include only “Controlled Closure” and “Cancelled”

In Phases filter : there should be two more option i.e "All Open" and "All Closed".

If I select "All Closed" then on the phases which is "Controlled Closure" and "Cancelled" are shown

and "All Open" then the phases which are "Awaiting Closure Evaluation " ,"Build","Deploy" ,"Design " should be shown.

How to get this selection in filters and there following expression.

I need to do this in every tab of my qlikview reports.

Samle Model attached.

[saumyashah90]

you will have to add one more column as this seems to be hierarchy

Make an Inline Table and

just make a outer join with the main table

[suvechha_b]

Hi Saumya,

Please help me in writing the inline table, as I am new in Qlikview.

Is it possible for you to write down for me.

Thanks

[jonathandienst · Accepted solution]

The best way to make these options selectable is to create a derived field in script. This field should be associated with the phases field. For example:

     PhaseFilters:

     LOAD * Inline

     [

          PhaseFilter, Phase

          All Open, Build

          All open, Deploy

          ...

          All Closed, Cancelled

          All Closed, Controlled Closure

          ...

     ];

If modifying the script is not possible, then you could create a button for each option, with a Select in Field action to select the appropriate phases, or even create a bookmark with the appropriate selections or each option.