Set analysis p function

[#1]

Hello,

I'm trying to use p function to reduce my dataset.

here my data :

No Article	Date	Type	Sales
10	20130930	I	30
20	20130930	A	20
10	20140930	I	20
20	20140930	I	20

I need to determinate the category sales evolultion

So I calculated the sales for the articles which were type I on 20130930 and which are always type I on 20140930

my function :

sum({Date = {20140930}, type={'I'}, noArticle = P({<Date={20130930}, type={'I'}>} noArticle) >} Sales)

but it not return all concern article

Where is my error ?

Thanks

[Gysbert_Wassenaar]

Works for me. Make sure to use the exact case sensitive field names.

[#3]

Yes ! Your example works for me too.

I use correct cas sensitive.

But in my app, I have to select a city to make it work.

This city is a synthetic key, does it wrong ?

Thank

[Gysbert_Wassenaar]

Well, there's no city field in the example data you posted. So your example is incomplete. That means I don't have any idea what's actually happening in your real application.

[#5]

Sorry, i started to work with 1 city to resolve the problem.

I updated your example to show you my problem

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#7]

Tanks for all