topic Re: set analysis script in QlikView

set analysis script

Fri, 18 Oct 2013 15:09:53 GMT

Hi,

I have data that when product is sold, it shows within the Retail Period (Year) for that part.

I want to count the number of Retaill Periods, by part.

At the moment Parts either have a status of Active (Y) or Non-Active (N)

How can I express this so it only counts the Active Parts, when I choose a Year?

({$<Year={$(=Only(Year))},(Active)=>}[Retail Period])

Thanks,

Paul

Re: set analysis script

MayilVahanan — Fri, 18 Oct 2013 15:13:39 GMT

Try like this

({$<Year={$(=Only(Year))}, Active= , Parts = {'Y'}>}[Retail Period])

Re: set analysis script

jagan — Fri, 18 Oct 2013 15:42:18 GMT

Hi,

Try like this

=Count({$<Year={$(=Max(Year))}, Parts = {'Y'}>} distinct [Retail Period])

Regards,

Jagan.

Re: set analysis script

Gysbert_Wassenaar — Fri, 18 Oct 2013 15:48:39 GMT

Something like this:

count({$<Year={$(=Only(Year))}, PartStatus={'Active (Y)'}>}[Retail Period])

Replace PartStatus with the name of the field that contains the status values for the parts. Replace 'Active (Y)' with the value that indicates active status.