Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Tejeswari_123
Contributor
Contributor

Chart expression Aggregation for a column is working only for one row in the straight table , where the aggregated column is repeating twice

Hi All,

I am trying to aggregate the values based on one column , it is working for one row where the aggregated column is repeating twice .

I have given below expression for this :

if (level =3, aggr(sum(a+b),column1)

kindly could anyone  help me here 

Thanks in Advance ,

Regards,

Tejeswari

Labels (1)
1 Reply
Or
MVP
MVP

Would be helpful if you provide a few sample rows and expected outcome here. There's nothing inherently wrong with the syntax that I can see, but without an understanding of what you're working with and what you're trying to achieve it's hard to be sure. That said, it is a bit unusual to see an un-aggregated aggr() function contained within an if() function - this is usually not what people are trying to achieve.