
Problem with calculation of a new field/expression over 2 dimensions
michel.barca Nov 2, 2010 5:09 AM (in response to michel.barca)Any help would be greatly appreciated!

Problem with calculation of a new field/expression over 2 dimensions
Roland Kunle Nov 2, 2010 6:10 AM (in response to michel.barca)Hi Michel,
I looked at your example  xls the other day. Unfortunatly I have no Idea how to solve your problem, especially the product vector with matrix. So I am waiting (with you) for some other answers. Or do you have another algorithm ?
Regards Roland

Problem with calculation of a new field/expression over 2 dimensions
michel.barca Nov 2, 2010 6:54 AM (in response to Roland Kunle )Roland,
I have gotten a little bit further, but I'm not there yet. The missing link now is that I need to create a pivot / matrix with the following values, where each row is equal to count( {<ddd_bucket= >} rel_vrd), but I have not been succesful in this last step yet:
j m o
i 3 1 
ii 3 1 
iii 3 1 
iiii 3 1 
I hope someone knows a "workaround" or trick. I think having matrices / tables in qlikview that can be dynamically updated (e.g. an extension of the variables concept) could make the tool extremely (more) powerful. This would allow many types of weighing and correction of data by demographic/population/etc.

Problem with calculation of a new field/expression over 2 dimensions
michel.barca Nov 9, 2010 1:43 PM (in response to michel.barca)Anyone?


