Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
LuisRomero
Contributor
Contributor

Filtrar credito

Buena tarde 

 

Soy muy nuevo con QV, necesito de su ayuda por favor . Necesito que mi gráfico solo me muestre un crédito en especial de la linea de crédito. 

barra.png

Labels (2)
1 Solution

Accepted Solutions
MayilVahanan

HI @LuisRomero 

You can't use sum() function in the dimension. If you want to use it, please use aggr function

Aggr(Sum(ur expression), LINEA_CREDITO)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
QFabian
MVP
MVP

Hola, como pusiste label SetAnalysis, supongo que eso quieres revisar, una expresión con set analisis sería asi :

count( {< tucampodecredito = {'tutexto o tunumero de credito'} >}   distinct [N°Ordenes])

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.
LuisRomero
Contributor
Contributor
Author

hice varios intentos con: count( {< tucampodecredito = {'tutexto o tunumero de credito'} >}   distinct [N°Ordenes])  y variables en campos , sigo obteniendo error en sintaxis adjunto imagen.linea.pngsyntaxis.png

Adjunto imágenes parte de la construcción del gráfico....

dimensiones .pngexpresiones.png

 

agradezco tu ayuda bastante...

MayilVahanan

HI @LuisRomero 

You can't use sum() function in the dimension. If you want to use it, please use aggr function

Aggr(Sum(ur expression), LINEA_CREDITO)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.