topic Re: Set analysis p function in QlikView

Set analysis p function

Fri, 31 Oct 2014 09:01:02 GMT

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

Re: Set analysis p function

Gysbert_Wassenaar — Fri, 31 Oct 2014 09:46:46 GMT

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

Re: Re: Set analysis p function

Fri, 31 Oct 2014 14:25:54 GMT

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

Re: Set analysis p function

Gysbert_Wassenaar — Fri, 31 Oct 2014 14:30:35 GMT

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.

Re: Re: Set analysis p function

Fri, 31 Oct 2014 15:11:29 GMT

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

I updated your example to show you my problem

Re: Re: Re: Set analysis p function

Gysbert_Wassenaar — Fri, 31 Oct 2014 15:30:39 GMT

See attached qvw.

Re: Re: Set analysis p function

Fri, 31 Oct 2014 15:42:24 GMT

Tanks for all