Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rammuthiah
Contributor II

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
Valued Contributor III

Re: System Logic

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
WhatsApp: 24 98152-1675
Skype: justen.thiago

Re: System Logic

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
Valued Contributor III

Re: System Logic

rammuthiah is your question solved?

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