topic Re: Select ongoing projects in QlikView

Select ongoing projects

Mon, 17 Nov 2014 08:21:09 GMT

I have a source with two tables.

Tab1
Projectnr (ex 1,2,3)
Timemode (ex order, documentation)

Tab2
Activity (ex finished, started, changed)
Timemode

A Project can have diffrent milestones (activities),
Started, Finishied, posted, changed and so on.

I want to find a way to see which projects are ongoing, that doesnt have the milestone "Finished" and as a uniqe projectnumber.

Re: Select ongoing projects

agomes1971 — Mon, 17 Nov 2014 08:25:06 GMT

Hi,

just have to add a column activity to your project table and then you'll have the relationship you want to see.

Regards

André Gomes

Re: Select ongoing projects

jagan — Mon, 17 Nov 2014 08:33:00 GMT

Hi,

What is the relation between Tab1 and Tab2? There should be Projectnr in Tab2 or Activity in Tab1 then only you can join two tables.

Regards,

jagan.

Re: Select ongoing projects

Mon, 17 Nov 2014 08:42:24 GMT

I have the column of activities but when you select activity "Started" for example I see all projects with this activity, but a project can have several activites "Finished" included,

And I only want to see the projects that doesnt have the activity "Finished"

For example:

Project 1 have the activites Started, Changed, Finished

Project 2 have the activites Started, Changed

Re: Select ongoing projects

Mon, 17 Nov 2014 08:45:56 GMT

The relation is Timemode.

Re: Select ongoing projects

jagan — Mon, 17 Nov 2014 08:58:56 GMT

Hi,

How you join the two tables with Timemode since all projects will have time modes? There should be Projectnr field in the tab2.

Can you attach sample file.

Regards,

Jagan.

Re: Select ongoing projects

michael_anthony — Mon, 17 Nov 2014 09:09:32 GMT

A chart with project number as dimension and expression if(Sum (if Activity = 'Finished',1)> 0,0,1). That should list projects without the finished activity.

Re: Select ongoing projects

Mon, 17 Nov 2014 09:33:23 GMT

This gives me a column that shows 0 or 1 depending on the activity is Finished (0) or have an other status (1)

This helps alot, is there a way in the chart always only show the milestones with status 1?

Re: Select ongoing projects

michael_anthony — Mon, 17 Nov 2014 09:38:02 GMT

Make sure turn on zero suppression in the chart properties.