topic Writing Script for mapping a few tables in QlikView https://community.qlik.com/t5/QlikView/Writing-Script-for-mapping-a-few-tables/m-p/391805#M698893 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>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:</P><P></P><P>Here is the data:</P><P>1. History: Key figure is KG</P><P>2. Future: Key figure is Amount</P><P>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"</P><P>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</P><P>5. Location: Map location with location names</P><P></P><P>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.</P><P></P><P>Many Thanks</P><P>Carmen</P></BODY></HTML> Thu, 29 Nov 2012 16:22:43 GMT 2012-11-29T16:22:43Z Writing Script for mapping a few tables https://community.qlik.com/t5/QlikView/Writing-Script-for-mapping-a-few-tables/m-p/391805#M698893 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>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:</P><P></P><P>Here is the data:</P><P>1. History: Key figure is KG</P><P>2. Future: Key figure is Amount</P><P>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"</P><P>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</P><P>5. Location: Map location with location names</P><P></P><P>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.</P><P></P><P>Many Thanks</P><P>Carmen</P></BODY></HTML> Thu, 29 Nov 2012 16:22:43 GMT https://community.qlik.com/t5/QlikView/Writing-Script-for-mapping-a-few-tables/m-p/391805#M698893 2012-11-29T16:22:43Z