Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

data mapping

i have transaction data where the total amount(excluding comps(discounts)) for the particular check(order) is calculated , i have another table with reasons for the comps and there ids , is there anyway i can figureout which comp is been used for which check ,and i want to have a flag for checks with comp and checks without comp.

i think this can be done by checking the relation between comps ,ItemSales,Payment

please find the attached excel with sample data and codes for comps.