Sum of Rows

[rkspareek1992]

Hi,

My expression is:

Sum({<LinkDate={'<=$(vDate)'}>}TSL)*only({<Date_Currency={'$(vMaxCurrencyDate)'}>}Rate_Currency1)

and I am  not getting sum of expression.

vDate is DataIland Date,

only({<Date_Currency={'$(vMaxCurrencyDate)'}>}Rate_Currency1)

is for selected Date_Currency and by default should show rate of max of Date_Currency.

Kindly suggest change in my expression.

[sunny_talwar]

You mean you are unable to get the correct totals or you are not getting a number on any row?

[rkspareek1992]

I am not getting total.

[sunny_talwar]

May be this

Sum(Aggr(Sum({<LinkDate={'<=$(vDate)'}>}TSL)*only({<Date_Currency={'$(vMaxCurrencyDate)'}>}Rate_Currency1), YourChartDimensionsHere))

[rkspareek1992]

Its not working....

Showing 0 as total.

[sunny_talwar]

Is this a straight table? Set Total Mode to Sum of rows on the expression tab to see if that works

[rkspareek1992]

Currently I am using straight table, but  I want to  use this expression in qliksense charts.

I have tried in  expression  tab by selection sum of  rows, then its  showing, But I wants same numbers in expression total.

Kindly suggest.

[sunny_talwar]

What all are your dimensions?

[rkspareek1992]

I can select any dimension for ex. Co.Code, Plant, Country etc.

[sunny_talwar]

Dimension in your straight table chart