Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis or Scripting?

Hi All,

What approach is best for this problem?

I have a table

IDID2Date
S-1111/17/2012
S-2112/12/2012
R-121/17/2012
R-1b35/4/2012
R-1c46/12/12

I need to get all the ID that have a count of 1 in ID2.

if(count(ID2)=1, ID)

So I need to get all the ID with only 1 count for ID2 and the specific date.

How can I achieve this?

Answer base on the table:

IDs..

R-1 - 1/17/2012

R-1b - 5/4/2012

R-1c - 6/12/12

I need to show this in Pivot Table.

Thanks,

Donna

3 Replies
sujeetsingh
Master III
Master III

Just go with set analysis

use calculated dimension...only({$<count(id2)=1>}ID)..

in expression just give ...Date

hope this help you..

Not applicable
Author

try with this expression :-

if(aggr(nodistinct count(ID2),ID2)=1,Date)

dimension :-

ID

Not applicable
Author

okay, i will try this one