Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
shivika123
Partner
Partner

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
Partner
Author

returning no value
shivika123
Partner
Partner
Author

returning blank
shivika123
Partner
Partner
Author

returning blank value
tresesco
MVP
MVP

Could you share your sample app to check?