Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rammuthiah
Creator III
Creator III

System Logic

I want to show the system for the project # based on the logic given below

Output:

Project #, System, Date

1,              D,         6/2/2018

Project

System

Finish Date

Current State

Based on the logic, I want to show the system where current state is equal to 1 and based on maximum Finish Date

1

A

30/07/2017

1

1

B

23/09/2015

0

1

C

29/11/2015

0

1

D

6/2/2018

1

1

E

25/07/2017

0

3 Replies
Thiago_Justen_

I'm not sure if I got your point, but here it is:

FirstSortedValue(System,-Aggr(If([Current State]=1,[Finish Date]),[Finish Date]))


This expression will give you System's location as you want.

Cheers

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
MK_QSL
MVP
MVP

Create a Straight Table

Dimension

Project

Expressions

Max({<[Current State] = {1}>}[Finish Date])

FirstSortedValue(System, -Aggr(Max({<[Current State] = {1}>}[Finish Date]),Project,System))

Thiago_Justen_

rammuthiah is your question solved?

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago