I have a data set with these fields, briefly: DATE, REGION,BRANCH,RM,SCORE.
DATE-BRANCH-RM together form a "unique" combination in the dataset and REGION-BRANCH-RM is a hierarchy.
Now, what I want to do is, to create a straight table chart with the columns;
"Region", "Branch", "RM, Score", "Rank(affected by selections)", "Rank(not affected by the selections other than DATE)".
This way, for example when a spesicific Region is selected, I expect the table to show the ranks of RM's in their region in one column, and the overall ranks of RM's in the other (rank among all RM's regardless of the region). Ranking will be calculated on the SCORE field as measure. As a second step then, I will need to write these ranks in two seperate text objects to display the ranks of a selected RM each time.
I made some search in the Community discussions and unlike my previous trials on different matters, I couldn't find a spesicific example exactly matching my case this time.
I would be more than pleased if anyone could help me on this.
I have solved this problem. By studying a few hours together with a number of searches on QlikCommunity, I figured out how to make a macro for this purpose and it worked out. For those interested, I have a chart having the ranks I need and I get the rank from the relevant cells of that chart by running a macro each time. As expected, I also have triggers to run the macro.
I have solved this problem. By studying a few hours together with a number of searches on QlikCommunity, I figured out how to make a macro for this purpose and it worked out. For those interested, I have a chart having the ranks I need and I get the rank from the relevant cells of that chart by running a macro each time. As expected, I also have triggers to run the macro.
