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: 
suvechha_b
Creator III
Creator III

Filters and Expressions

Capture.PNG

• 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.

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
saumyashah90
Specialist
Specialist

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

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
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein