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

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

Tejeswari_123 — Thu, 14 Jul 2022 15:05:21 GMT

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

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

Or — Thu, 14 Jul 2022 16:16:54 GMT

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.