Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

qlik4asif
Contributor II

Need Help On set analysis

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


Tags (1)
4 Replies

Re: Need Help On set analysis

What Only(Manufacturers) returning?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
isingh30
Valued Contributor

Re: Need Help On set analysis

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

isingh30
Valued Contributor

Re: Need Help On set analysis

Can you share your data in excel format?

qlik4asif
Contributor II

Re: Need Help On set analysis

Yes Anil, need Manufacturers who satisfies above condition.