Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

problem with sort by expression in pivot table

hello to all,

i am a beginer of qlik and i have a simple question (i think) that I have not found an answer in the community.

given this data

agcliqtyimp
AC0011120
AC0021100
AC0031130
AC00401,01
BC0013500
CC0061160

in a pivot table i want to sort by AG in alphabetical, and then CLI by descending sum(imp)

i cannot find the correct way to do this.

the problem is the CLI C001 is present ni AGE A and B ..... this situation make incorrect order by expression

as you can see in the attachment.

can you help me ?

thanks in advance

Community Browser