topic Re: Filters and Expressions in QlikView

Filters and Expressions

suvechha_b — Mon, 07 Dec 2015 09:49:18 GMT

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

Re: Filters and Expressions

saumyashah90 — Mon, 07 Dec 2015 09:57:59 GMT

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

Re: Filters and Expressions

suvechha_b — Mon, 07 Dec 2015 10:00:35 GMT

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

Re: Filters and Expressions

jonathandienst — Mon, 07 Dec 2015 10:03:20 GMT

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.