Diferent sort same match()

[pgalvezt]

Hello,

Help me with this please,

I got the same formula but qlikview thrown different sort in pivot. I need the same sort "listbox"

Thanks!

[Peter_Cammaert]

What do you mean? You already have the exact same sort order as the listbox, but the pivot lacks some items because the expression produces a 0 value. Disable the "Suppress zero values" checkbox in Properties->Presentation and your pivot table will match the listbox.

[pgalvezt]

Hi, thank you for your reply.

I disabled the "Suppress zero values" but stll show differents sorts. (I have the same formula) I will expect the same result.

Thanks!

[Peter_Cammaert]

Can you post a screenshot of what you are seeing? It appears that the document alone will not explain your trouble.

[Peter_Cammaert]

When looking at your Sort expression, I can see that it has one additional item that doesn't appear in either your pivot table or your list box. If the field cc_group_desc has no value called 'OTROS INGRESOS DE LA EXPLOTACION' (see listbox) then QlikView obviously can't show it. But apart from that, the sort order is correct.

See below:

[pgalvezt]

I attached the screen

[Peter_Cammaert]

I'm a bit clueless at the moment.

The same document has a different sort order (that cannot be explained) in your desktop as in mine...

What version of QV Desktop are you using?

[pgalvezt]

8.5

[Peter_Cammaert]

Wow, I feel sorry for you already. You're missing all these thousands of bug fixes, new features and performance improvements.

If I remember correctly, there were some sorting problems in pivot tables with QV versions before 9 or even with v9 itself. Any chance of an upgrade?

Sorry I coudn't help you out.