Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
MVP & Luminary
MVP & Luminary

Re: Re: Re: Set analysis p function

See attached qvw.


talk is cheap, supply exceeds demand
6 Replies
MVP & Luminary
MVP & Luminary

Re: Set analysis p function

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


talk is cheap, supply exceeds demand
Not applicable

Re: Re: Set analysis p function

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

MVP & Luminary
MVP & Luminary

Re: Set analysis p function

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

Re: Re: Set analysis p function

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

I updated your example to show you my problem

MVP & Luminary
MVP & Luminary

Re: Re: Re: Set analysis p function

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Re: Set analysis p function

Tanks for all