How to count distinct Value having id_calendar > current id_calendar_abo

[sarafamiglietti]

Hello

I hava a table like below:

id_abo	id_calendar_abo	Name
1	5814	A
2	5814	A
3	5815	A
4	5816	A
5	5815	B

When I select an id_calendar_abo, I want to create a pivot table to know the number of distinct Name having id_calendar_abo > id_calendar_abo selected

This is the pivot table I expect:

id_calendar_abo selected	count distinct Name where id_calendar_abo > current id_calendar_abo
5814	2
5815	1
5816	0

My problem is :

When I select an id_calendar_abo, for example 5814, Qlikview calculates : count distinct Name where 5814>5814, so there is no result.

Can someone help me?

Thanks&Regards

Sara

[sunny_talwar]

How did you get a count of 2 for 5814? There is only 1 DISTINCT NAME (A)

[sarafamiglietti]

For id_calendar_abo = 5814, I want distinct Name in the table where id_calendar_abo > 5814.

So I want to retrieve:

5815 A

5816 A

5815 B

And if I calculate distinct name, I have A and B so 2.

[Chanty4u]

=Sum(Aggr(Count(id_calendar_abo)DISTINCT Name))

[Chanty4u]

=Count(Distinct id_calendar_abo > 5814)

[#6]

Hi Sara,

Can you please try the attached script and let me know if you have any issues.

Thanks,
Sreeman

[sarafamiglietti · Accepted solution]

Hi screemannaraya,

I tried the script but it did not resolve my issue.

Finally I found a workaround by creating a separate calendar.

Thanks for your help.

Sara