Question on building an inventory alert

[#1]

I receive a file from a customer with all of their store sites listed and the tank volumes in each tank. the sites vary in the following:

1. Product Types

2. Tank Sizes

3. Tank Configuration

4. Maximum Volume

5. Current volume

What I would like to do is build a QV application that would scan all the site data and report when when the following conditions are true:

1. UNL tanks have a volume level of at, or below 4000 gallons

2. Premium Tanks have a volume at, or greater than 3000 gallons

3. Diesel Tanks that are at, or greater than 3000 gallons

I would like to build this application to be a button driven application, as this file is all inclusive of the information I need it to alert my dispatchers when specific tank volumes are at a critical state so a load can be planned, without having to select numerous variables.

I think the variables that can be specified would be the Types of product.

[rwunderlich]

1. Load the customer tank file.

2. Create a chart with Dimensions Customer, TankID. Maximum Volume, etc.

3. Use a chart expression that filters with a Set Expression to the thresholds you want: Something like:

Sum({ <TankConfiguration={'UNL'},CurrentVolume={">=4000"}>

+ <TankConfiguration={'Premium '},CurrentVolume={">=3000"}>

+  <TankConfiguration={'Diesel '},CurrentVolume={">=3000"}> }

CurrentVolume)

I'm not sure exactly how you mean to use this. As a chart that someone looks at or do you want to send an email alert after reload?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com