Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Rebecca
Contributor
Contributor

Only show latest project

Hello Community,

I need your help with the following topic. 
I have an excel table with the columns below: 

project / status / date 

For each project it is possible to change the status more then once a month. 
At the end of each month I want to know the latest project status of the month. (E.g. at the 01.02 project status was 'nok' but it changed on 20.02 to 'ok') 
If I use the count function in the table chart I can see both project status in February. Instead I only want to see the 'ok' status. 

Have you any advice how to handle? 

Thanks in advance! 
Rebecca

Labels (2)
1 Solution

Accepted Solutions
JordyWegman
Partner
Partner

Hi Rebecca,

Try to use the Max(Date) with your status dimension. I can't imagine that these kind of statuses change on the same day right? 

Using the max date will give you the last status of that project.

Jordy

Climber 

Work smarter, not harder

View solution in original post

1 Reply
JordyWegman
Partner
Partner

Hi Rebecca,

Try to use the Max(Date) with your status dimension. I can't imagine that these kind of statuses change on the same day right? 

Using the max date will give you the last status of that project.

Jordy

Climber 

Work smarter, not harder

View solution in original post