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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I use AGGR function with an exppresion instead of a field ?

Hi, I´m having a problem with The aggr Function. Í am  building an object with a calculated dimension ex: IF (CUST_SALES<'0' , CUST). Now I´m trying to build an object to filter the first one, in this filter i have to use an aggr function, and i want to use the function over the expression above instead of the field, more or less this way:

 

        AGGR  ( EXPRESSION , (IF (CUST_SALES<'0' , CUST)) )

Thnk you Guys

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

Hi,

I'm not sure if I understood you correctly, but you could try this:

     AGGR  ( if( CUST_SALES<0, EXPRESSION) ,CUST )

If it doesn't work, please share a data sample and we can try it on a qvw

Hope it helps,

Erich

View solution in original post

2 Replies
erichshiino
Partner - Master
Partner - Master

Hi,

I'm not sure if I understood you correctly, but you could try this:

     AGGR  ( if( CUST_SALES<0, EXPRESSION) ,CUST )

If it doesn't work, please share a data sample and we can try it on a qvw

Hope it helps,

Erich

Not applicable
Author

Thanks Erich, it works !!!