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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
danielrr890
Contributor
Contributor

Including add to expresion whit if

Hello greetings
I need to add including  "Dia = Aggr (Nodistinct Max (Dia), Mes)" in the expression

=Sum(
{<Comparacion = {'APLICA'},
ESTADO_CARTERA = {'ACTIVO'},
AparicionStatus = {'0'},
FONDEADOR ={' LIBRAVAL ','LIBRAVAL'}
>} BASE_PROVISION)


Thanks!
1 Solution

Accepted Solutions
sunny_talwar

May be this

=Sum(
{<Comparacion = {'APLICA'},
ESTADO_CARTERA = {'ACTIVO'},
AparicionStatus = {'0'},
FONDEADOR ={' LIBRAVAL ','LIBRAVAL'},
Dia = {"=
Dia = Aggr (Nodistinct Max (Dia), Mes)"}
>} BASE_PROVISION)

View solution in original post

2 Replies
sunny_talwar

May be this

=Sum(
{<Comparacion = {'APLICA'},
ESTADO_CARTERA = {'ACTIVO'},
AparicionStatus = {'0'},
FONDEADOR ={' LIBRAVAL ','LIBRAVAL'},
Dia = {"=
Dia = Aggr (Nodistinct Max (Dia), Mes)"}
>} BASE_PROVISION)
danielrr890
Contributor
Contributor
Author

Thanks... Perfect!