Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Pick match valuelist

Tengo el siguiente código  en una tabla con valuelist():

num(sum( {<Stream={'IMS DATA'},Corporation={'Sanofi Corp','Sanofi INN'},Periodo={'MTH10'}>} aggr( Tot, Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family, Tot))/sum( {<Stream={'IMS DATA'},Periodo={'MTH10'}>} aggr( Tot, Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family, Tot)) ,'#.0%')

Pero no muestra el resultado en mi tabla.

PICK(MATCH(VALUELIST($(vLista)),$(vLista)),
$(vF1C11),
$(vF2C11),
$(vF3C11),
$(vF4C11),
'',
$(vF6C11),
$(vF7C11),
$(vF8C11),
$(vF9C11),
$(vF9.1C11),

'',
num(sum( {<Stream={'IMS DATA'},Corporation={'Sanofi Corp','Sanofi INN'},Periodo={'MTH10'}>} aggr( Tot, Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family, Tot))/sum( {<Stream={'IMS DATA'},Periodo={'MTH10'}>} aggr( Tot, Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family, Tot)) ,'#.0%'),
$(vF12C11),
$(vF13C11),
$(vF14C11),
'',
$(vF16C11),
'')

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Re: Pick match valuelist

Hola

Creo que solo faltaba alguna función de medición para AGGR

num(
	sum({<Stream={'IMS DATA'},Corporation={'Sanofi Corp','Sanofi INN'},Periodo={'MTH10'}>} 
		aggr(
			sum(Tot), Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family
		)
	)
	
	/
	
	sum({<Stream={'IMS DATA'},Periodo={'MTH10'}>} 
		aggr(
			sum(Tot), Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family
		)
	) 
,'#.0%')

saludos

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng

View solution in original post

1 Reply
Highlighted
Creator II
Creator II

Re: Pick match valuelist

Hola

Creo que solo faltaba alguna función de medición para AGGR

num(
	sum({<Stream={'IMS DATA'},Corporation={'Sanofi Corp','Sanofi INN'},Periodo={'MTH10'}>} 
		aggr(
			sum(Tot), Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family
		)
	)
	
	/
	
	sum({<Stream={'IMS DATA'},Periodo={'MTH10'}>} 
		aggr(
			sum(Tot), Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family
		)
	) 
,'#.0%')

saludos

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng

View solution in original post