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

Set analysis p function

Hello,

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

here my data :

No ArticleDateTypeSales
1020130930I30
2020130930A20
1020140930I20
2020140930I20

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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

I updated your example to show you my problem

Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

Tanks for all