Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help with expression

Hi,

I need to change the way the "GAP" gets calculated within the attached Straight Table. The different parts to the formula are...

Average Sales = Total Sales / # Stores with Sales

If the Sales value (by Barcode/Store) is less than the Average, then the GAP = Average Sales - Sales (by Barcode / Store)

The easy part is to add the Average Sales column, but how would I test the Sales value (by Barcode/Store) against the Average Sales value without the Store being included withing this table?

Table.png

0 Replies