Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlik4asif
Creator III
Creator III

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


4 Replies
Anil_Babu_Samineni

What Only(Manufacturers) returning?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
isingh30
Specialist
Specialist

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

isingh30
Specialist
Specialist

Can you share your data in excel format?

qlik4asif
Creator III
Creator III
Author

Yes Anil, need Manufacturers who satisfies above condition.