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

need help

Hi Comunity,

I want to evaluate distinct count of ids

My desired output should be like this

date, id

1-Jan, 10

2-Jan, 15

3-jan, 20

any help?

See below attached for your reference.

1 Solution

Accepted Solutions
sunny_talwar

May be using a flag:

Table:

LOAD id,

    date

FROM

doubt.xlsx

(ooxml, embedded labels, table is Sheet1);

FinalTable:

LOAD id,

  date,

  If(id = Peek('id'), 1, 0) as Flag

Resident Table

Order By id, date;

DROP Table Table;


Capture.PNG

View solution in original post

6 Replies
Colin-Albert

Load the data, then create a straight table chart with date as a dimension, and count(distinct id) as the expression.

Not applicable
Author

Yes! I tried the same but no result as am exactly looking for

It shows only,

1-Jan 10

2-Jan 20

3-Jan 30

Any more ideas?

Kushal_Chawda

LOAD Date,

          Count(ID) as Id_Count

FROM Table

group by Date;

Not applicable
Author

No...In Script & UI I tried the same before posting.

But no use.

sunny_talwar

May be using a flag:

Table:

LOAD id,

    date

FROM

doubt.xlsx

(ooxml, embedded labels, table is Sheet1);

FinalTable:

LOAD id,

  date,

  If(id = Peek('id'), 1, 0) as Flag

Resident Table

Order By id, date;

DROP Table Table;


Capture.PNG

Not applicable
Author

This is exactly what I looking for,

Thanks Sunny!!!!