Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Calculation method for a field

hello ,

                       all i am trying to calculate average selling price ( dollars / quantity )for an item that is sold in the company . The calculation method is to find unique values based upon the key ( which is  Item & region code& week ) everything is fine until when there exits a match based upon the key . The issue arrives when there is no match , the calculation in this scenario is  to find unique values based upon the key ( which is  Item & region code& week minus one  ) . i tried various methods by doing all the necessary calculations  for Item & region code& week minus one  separately  in the script and joined to the data model ( didn't work). i did some front end expression by using variables didn't work . any help would be great . All the tables  in the dashboard are connected by  unique key ( which is Item & region code& week ).

Tags (1)