Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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

View solution in original post

Not applicable
Author

Tanks for all