Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select ongoing projects

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.

1 Solution

Accepted Solutions
michael_anthony
Creator II
Creator II

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.

View solution in original post

8 Replies
agomes1971
Specialist II
Specialist II

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

jagan
MVP
MVP

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.

Not applicable
Author

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

Not applicable
Author

The relation is Timemode.

jagan
MVP
MVP

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.

michael_anthony
Creator II
Creator II

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.

View solution in original post

Not applicable
Author

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?

michael_anthony
Creator II
Creator II

Make sure turn on zero suppression in the chart properties.