Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

how to pick a value

Hi All,i need help in one of my requirement,for example i got like below

Place       customer                       value

LP               fox                             1000

LP               fox                             2000

LP               fox                             3000

LP               happy                         8000

LP               happy                         6000

LP               happy                         7000

DS               fox                             10000

DS               fox                             90000

DS               fox                             30000

DS               happy                         10008

DS               happy                         1032

DS            happy                         1067


so now i need to write a expression in a way that,if i select

LP value from Place field and fox as customer then it should pick one value from the above three values (1000,2000,3000)

LP value from Place field and happy as customer then it should pick one value from the above three values (8000,6000,7000)

i mean the expression should be dynamic .....

Note :This is just a sample values ,In client data i got more value (more then 3)for each customer .......



thanks

naveen


1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try using =Max(value) as an expression.

View solution in original post

9 Replies
tresesco
MVP
MVP

naveen kumar wrote:

if i select

LP value from Place field and fox as customer then it should pick one value from the above three values (1000,2000,3000)

'one value' - which one, do you have a logic for that?

kunkumnaveen
Specialist
Specialist
Author

HI

LP value from Place field and fox as customer then it should pick any one value from the above three values (1000,2000,3000)


i mean it can show either 1000 or 2000 or 3000

tresesco
MVP
MVP

Try using =Max(value) as an expression.

kunkumnaveen
Specialist
Specialist
Author

I tried =max(value) ,instead of displaying the max value from (1000,2000,3000) it giving out 3 as value

tresesco
MVP
MVP

Where are you using this expression? in a chart? if so what are the dimensions are you using? Could you post a sample qvw?

jonathandienst
Partner - Champion III
Partner - Champion III

That's not consistent with the data in your original post, so there is more to this. If the possible values are 1000, 2000, 3000, then Max(value) will return 3000.

I suggest that you upload a small sample qvw with representative data showing where you get 3 instead of 3000.

Preparing examples for Upload - Reduction and Data Scrambling

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
shraddha_g
Partner - Master III
Partner - Master III

Have a look.

kunkumnaveen
Specialist
Specialist
Author

yes in a bar chart ,

dimension : Place

expression:=max(value)

tresesco
MVP
MVP

There is definitely something that is being missed. Try to share your sample qvw to look into.