Pivot Table : Create two buttons (show first 10 lines or show total lines)

[Thathayoyo]

Hello,

I have a pivot table that looks like the example below. I have already created two buttons that allows you to sort either in ascending or descending order based on the "Quantity" column.

I am now looking to create two buttons ( first 10 lines or Total lines) which depending on the dimension 1 which we choose to put first, allow us to display either the first 10 lines or the total lines. How to do it?

Thanks.

(image from Qlik documentation)

[sbaro_bd · Accepted solution]

Hi @Thathayoyo ,

See the attached qvf file.

Regards.