Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try using =Max(value) as an expression.
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?
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
Try using =Max(value) as an expression.
I tried =max(value) ,instead of displaying the max value from (1000,2000,3000) it giving out 3 as value
Where are you using this expression? in a chart? if so what are the dimensions are you using? Could you post a sample qvw?
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
Have a look.
yes in a bar chart ,
dimension : Place
expression:=max(value)
There is definitely something that is being missed. Try to share your sample qvw to look into.