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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

When production exceeds 100 Serial number, display the date

Hello everybody,

I have a problem I can not solve. I think we should use a Set Analysis.

Here is my table:

Serial Number              Date             Reference

00001                      01/10/2010             A

00002                      05/10/2010             B

00455                      25/11/2010             A

15102                      30/11/2010             A

48520                      02/12/2010             A

15621                      03/12/2010             B

15672                      08/12/2010             A

65421                      01/01/2011             A

15642                      25/01/2011             B

23486                      15/03/2011             B

15674                      14/06/2011             A

15244                      01/11/2011             A

57869                      02/11/2011             A

46571                      15/01/2012             A

What I would like to know it's the date on which a reference has been more than 5 products Serial Number:

Approximately:

When count (Serial Number) = 5 then

                 DATE

Group by Reference



For the Reference A, i want : 08/12/2010

For the Reference B, i don't want a Date because I have 4 SN.

I want this in a PivotTable.

In my dimension I would have Reference and in my expression my date.

Please help me.

(sorry for my bad English ...)

Regards.

Cyril

3 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

I have created without using set analysis. Please check the attachment. I hope this helps.

Deepak

Not applicable
Author

Thank you for you answer.

But it's not what I want...

I want to know when the fifth product was created but I may have 50 products ... So if(Count(Reference)=5,Max(Date))  does not work in this case.


if(Count(Reference)>=5,fifth date)  This might work but i don't know how to retrieve the 5th value.

deepakk
Partner - Specialist III
Partner - Specialist III

Hi,

Try out this application.

Deepak