Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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.

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: need help

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
Highlighted

Re: need help

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

Highlighted
Not applicable

Re: need help

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?

Highlighted

Re: need help

LOAD Date,

          Count(ID) as Id_Count

FROM Table

group by Date;

Highlighted
Not applicable

Re: need help

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

But no use.

Highlighted

Re: need help

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

Highlighted
Not applicable

Re: need help

This is exactly what I looking for,

Thanks Sunny!!!!