Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Count number of cases that happens once in a period

Hi guys,

I'm facing an issue to find a expression that counts the number of ID's that happens only once in a period of days.

Example: in the last 15 days I have the following ID's appearing in a log file:

X

Y

Z

W

Y

K

Z

I can see that Y and Z appeared more than once in this period, so I need an expression that will give me the result equal to 3 (that is the number of IDs that only appeared once in this interval = X, W and K). Any ideas?

Thankss!

1 Solution

Accepted Solutions

Re: Count number of cases that happens once in a period

May be like this:

Count({<ID = {"=Count(ID) = 1"}>}ID)

1 Reply

Re: Count number of cases that happens once in a period

May be like this:

Count({<ID = {"=Count(ID) = 1"}>}ID)