Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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.