tutorial sales per country sort

[#1]

Hi,

New to Qlikview, using it through partner with Moody's. Working through the tutorial on version 11.20 and can't replicate the sort order change described on p. 70. Followed the steps, and my countries are still sorted in alpha. Checked the TutorialFinal.qvw file to compare the settings to my own and the only difference I see is ascending v descending for the Sales Numeric Value sort order. Even though TutorialFinal.qvw is set to ascending, the sales totals are displayed in descending as well. Am I missing something?

Thanks,

Steve

[pho3nix90]

Extremely strange, this is what I am greeted with when opening your tutorial properties  (see screenshot at the bottom).

It might be a bug, or very outdated version of qlikview, what version are you using?

From your last screenshot, I would suggest in that scenario to move sales to the top priority in the list of 2 by clicking on sales and then clicking "Promote", and removing the sort by text.

Also as a side note, this is a bar chart and not a pivot

[#3]

Version is 11.2 (SR11), but the tutorial I'm following was downloaded from the link provided on the splash page of this product version as well, which is why I'd be surprised if they weren't in synch. I follow the difference between the pivot and the bar, I was just remarking that I see the Y-value option for pivot tables and do not see it for bars. I also tried to promote Sales as you suggested and that did not work either - in fact, nothing changed at all, which increased my suspicion that what I was seeing is a bug. Based on Digvijay's findings, others seem to have encountered the same thing and apparently by setting the Y-value in a different chart type, the selection is preserved when you switch back to a bar.

In any case, using an Expression sort on country by sum(sales) seems to make the most sense to me. It accomplishes the goal and is very readable for maintenance purposes.

[Digvijay_Singh]

Happy to hear that it got resolved.