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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mayur2mistry
Contributor
Contributor

Usage of Single field in Dimension and Measure both

I want to compare Stock quantity against the minimum stock level defined. But  the sum of Stocks having different categories and like in progress , spare , in inspection etc. and that is too at multiple storage locations in same plant. like Storage location A , B , C and i want total stock of Single material according to storage location and compare to minimum stock level . If Total stock > minimum , Stock is in GREEN else RED. Final requirement is total no. of materials in GREEN and RED

0 Replies