Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
shivika123
Partner - Contributor
Partner - Contributor

write a set analysis tohighest all the product whose sales value is maximim

Suppose I have a table

product sales 

a        30

b   30

c  10

d  5

need to write set analysis to get a and b value in a text box because it has maximum sales value.

Labels (1)
7 Replies
rahulpawarb
Specialist III
Specialist III

May be this..

//Define a variable - eMaxSales

=Max(Sales)

//Text  box expression

Concat({<Product={"=Sum(Sales) = $(eMaxSales)"}>}Product, Chr(10))

 

- Rahul

HirisH_V7
Master
Master

=Concat({<ID = {"=Rank(Sum(Sales))=1"}>} DISTINCT ID,', ')

Usethis

HirisH
“Aspire to Inspire before we Expire!”
tresesco
MVP
MVP

=Concat(DISTINCT {<Product={"=Rank(Sum(Sales))=1"}>} Product, ',')
shivika123
Partner - Contributor
Partner - Contributor
Author

returning no value
shivika123
Partner - Contributor
Partner - Contributor
Author

returning blank
shivika123
Partner - Contributor
Partner - Contributor
Author

returning blank value
tresesco
MVP
MVP

Could you share your sample app to check?