How to group a field in Qlikview expressions?

[nivas30kumar]

Hi All,

Please help me in this Issue. Your help is most appreciated. 

i have fields like CLINENO,CNUMBER,CLINENUMBER , Now i want to group them with expression. 

if i select one value in  CNUMBER  i am getting two values for CLINENUMBER 

but i want only 1 CLINENUMBER  must be selected in the chart. 

 see the below example.

CNUMBER	CLINENUMBER	CLINENO
0809121822069	8091218220691	1
	8091218220692	2
0809121822075	8091218220756	6
	8091218220757	7
	80912182207512	12

so if i select  CNUMBER  0809121822069 , then i want get displayed with this CLINENUMBER  8091218220692

The same here also CNUMBER 0809121822075 and expected is CLINENUMBER  80912182207512.

It should be displayed Based on Max CLINENO. 

[sunny_talwar]

May be try this

Dimension

CNUMBER

Expression

FirstSortedValue(CLINENUMBER, -CLINENO)

[nivas30kumar]

Hey Sorry that is not working with my condition.

Can some one please help me on this 

[sunny_talwar]

Sure thing!! Would you be able to share a sample where we can see this not working with your conditions?