Discussion Board for collaboration on QlikView Scripting.
I have a sheet called data and a sheet called points. I want to join the score1, score2, score3, score4 from the data sheet to the points sheet. Take the weight from the point sheet muliple it by the data sheet and sum it up for each company.
Please find the attached file and let me know is this the desired result
(ooxml, embedded labels, table is Data);
(ooxml, embedded labels, table is Weight);
You can use CrossTable.
See the blog post currently available in your Qlik Community home tab
Look at the attacched file...
Hope this helps
How do I also have another column that is the sum of all the multiplied scores?
Can u elaborate your result in excel file. I understand what u need but if you display column wise result then it fesible for me to clearly understand your requirement
Look this new example in the attacchemnt.
Hope this helps.
CrossTable(Name,Score,1)LOAD Comp, Score1, Score2, Score3, Score4FROMC:\testdata.xlsx(ooxml, embedded labels, table is Data);Left JoinLOAD Name, WeightFROMC:\testdata.xlsx(ooxml, embedded labels, table is Weight);
If this is not correct then reply with your required result..
With a left join there you run the risk of duplicating rows in the main table with duplicate weights. I would suggest an ApplyMap, or simply leaving as an association.