topic Re: Need Help On set analysis in QlikView

Need Help On set analysis

qlik4asif — Wed, 25 Nov 2020 16:16:04 GMT

I want to find the Manufacturers whose sales are over 100,000 for the 2 categories CHEESE CAKE and ACC in January 2013 (period P01/13). But I want to remove from that list those whose sales are lower than 50,000 for all categories in January 2012:

write set analysis code for this

I tried with this

Only({<Sales={">100000"},categories={'CHEESE CAKE' ,'ACC' },period={'P01/13'}>-<Sales={"<50000"},categories={*},Period={'P01/12' } >Manufacturers})

Can some one correct this expression.

Thanks in advance

Re: Need Help On set analysis

Anil_Babu_Samineni — Fri, 25 May 2018 09:45:42 GMT

What Only(Manufacturers) returning?

Re: Need Help On set analysis

isingh30 — Fri, 25 May 2018 10:17:31 GMT

Only({<Sales={">100000"},categories={'CHEESE CAKE' ,'ACC' },period={'P01/13'} - Sales={"<50000"},categories={*},Period={'P01/12' }>}Manufacturers)

Re: Need Help On set analysis

isingh30 — Fri, 25 May 2018 10:18:10 GMT

Can you share your data in excel format?

Re: Need Help On set analysis

qlik4asif — Fri, 25 May 2018 10:20:08 GMT

Yes Anil, need Manufacturers who satisfies above condition.