topic Re: need help in QlikView

need help

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: need help

Colin-Albert — Tue, 05 Apr 2016 16:58:36 GMT

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

Re: need help

Tue, 05 Apr 2016 17:05:06 GMT

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?

Re: need help

Kushal_Chawda — Tue, 05 Apr 2016 17:09:21 GMT

LOAD Date,

Count(ID) as Id_Count

FROM Table

group by Date;

Re: need help

Tue, 05 Apr 2016 17:32:42 GMT

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

But no use.

Re: need help

sunny_talwar — Tue, 05 Apr 2016 18:11:03 GMT

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;

Re: need help

Tue, 05 Apr 2016 18:41:19 GMT

This is exactly what I looking for,

Thanks Sunny!!!!