Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ericdanqua
Creator
Creator

Top N product in a text object

Hello,

I am trying to format a label box to show the top 2 product and their values. so for a table such as the below

Table:

LOAD * INLINE [

    Product, Value

    A, 10

    B, 20

    C, 30

    A, 12

    B, 25

    C, 31

];

I want to display in a text object or chart label the following.

Top 2 Products:

B 45

C 61

How could this be achieved please.

thanks in advance

1 Solution

Accepted Solutions
tresesco
MVP
MVP

1 Reply
tresesco
MVP
MVP

PFA

Capture.JPG