I have created a bar chart in qlik sense with colormix expression in the tab colors and legend in order to change color in the values of the dimension according to the sales of the current year. The expression is the following.
Hello, I have already put the number 1 but nothing is changing. The problem is in the rank total of the summation of sales because when i select a value it takes the number 1 . I can't find the way how i keep the rank of this selection before the selection. From the other hand i have to create a variable to keep stable the NoOfRows(TOTAL) that a have already done.
Finally, I don't understand the comment you wrote :
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Of cource i have look for a solution in the web and in the community and i can't find anything for this problem and for that reason i placed the question to the community.