Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Writing Script for mapping a few tables

Hi all

I am a beginner of Qlikview report developer and have a question how to use proper syntax and function of Qlikview to do the following:

Here is the data:

1. History: Key figure is KG

2. Future: Key figure is Amount

3. Unit: Since the key figure of worksheet "Future" is based on different unit, a conversion table is used to convert the Amount into new variable Amount (KG) to make the apple-to-apple comparsion with key figure in worksheet "History"

4. Segment: There is a rule to segment data in "History" and "Future". if key of Product-Location in "History" or "Future" found in the worksheet "segement", assign the segment of this Product-Location to map the key figure. If the Location in "History" or "Future" found in the worksheet "segement", assign the segment of this Product to map the key figure

5. Location: Map location with location names

I have made a table in worksheet "Result" which the data supposed should look like this way if I run the straight table in the report.

Many Thanks

Carmen

Community Browser