topic Re: Exclude a project in QlikView

Exclude a project

nickploeg1998 — Wed, 25 Nov 2020 16:16:04 GMT

Hii,

I'm making a dashboard were you can see all the costs per project (called 'VTW nummer'). So every project has different costs. Now there is 1 project called 'S-VTW-009' who has such high costs that it **bleep**s up the dashboard. So I want to make a button at the top of the dashboard when I press on it that it selects everything and EXCLUDES 'S-VTW-009'. This way I can show everyone what the effect is of this one project, then delete it from the dashboard and continu making conclusions.

I hope you understand me.

I uploaden the Excel sheet what I use. 'VTW nummer' are the projects and 'Financiële consequenties' are the costs.

Right now I deleted 'S-VTW-009' from the Excel because I was unable to make this button. When one of you has the solution I will add it back to the Excel and reload Qlikview.

Re: Exclude a project

zhadrakas — Thu, 02 May 2019 13:01:27 GMT

The easiest way is:
1) Create a Button
2) set an Action "Select in Field"
-> Field = Project -> Search String = 'S-VTW-009'
3) set another Action "Select Excluded"
-> Field = Project

This way all Projects except 'S-VTW-009' are selected on Button Click.
if there are more Projects you want to exclude think about using a Bookmark instead of "Select Field Action" in step 2.

Antoher Way is removing this Project from your object in Dimension or Expression:
Dimension: if(Project<> 'S-VTW-009', Project)
-> Exclude NULL Values

regards
tim

Re: Exclude a project

nickploeg1998 — Thu, 02 May 2019 13:30:39 GMT

It's not working (see pics).

Re: Exclude a project

nickploeg1998 — Thu, 02 May 2019 13:31:56 GMT

This Excel is including VTW-009

Re: Exclude a project

zhadrakas — Fri, 03 May 2019 05:45:43 GMT

for all your Actions check your "field" again.

Put [] around your field cause there is a blank in the field Name.

i usually add a = at the start to get the autocomplete and then remove the = afterwards.