Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

irmantas
New Contributor II

How find MAX date with were?

Hi Folks,

I have Table like this:

ItemId     OperationDate     Qty     StatusReceipt     StatusIssue

XX          03/03/2017          1          Purch    

XX          05/03/2017          1                                   Sale

XX          06/03/2017          1          Ordered

How I can find ItemId firs date of Purch and Last date of Sale in Expression?

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: How find MAX date with were?

May be this

Dimension

ItemId

First date of Purch

Min({<StatusReceipt = {'Purch'}>}OperationDate)

Last date of Sale

Max({<StatusIssue = {'Sale'}>}OperationDate)

2 Replies
MVP
MVP

Re: How find MAX date with were?

May be this

Dimension

ItemId

First date of Purch

Min({<StatusReceipt = {'Purch'}>}OperationDate)

Last date of Sale

Max({<StatusIssue = {'Sale'}>}OperationDate)

irmantas
New Contributor II

Re: How find MAX date with were?

Thank you Sunny. it's works.