Display last date values in straight table

[nazaninslp]

Dears

I have straight table, and I want show the last date values in my chart based on categories.

would you please help me.

Dimension : Category

expression :

I've tried both of them and they show all of values that they had til now.

1- sum({<Date_key={"$(=Date(max(DATE_KEY),'YYYY-MM-DD')))"}>} NEW_SUBSCRIPTION_COUNT)

2- sum({<date_key={"$(=max(date_key))"},Category-={"Test","Free ShortCode","Xtratime"}>} NEW_SUBSCRIPTION_COUNT)

[arvind_patil]

Hi NAzanin,

Please try below:

sum({<Date_key={"$(=Date(max(<Category>DATE_KEY),'YYYY-MM-DD')))"}>} NEW_SUBSCRIPTION_COUNT)

Thanks,

Arvind Patil

[Anonymous]

I tried something similiar in my straight table and it works like sum({<field1={'$(=max(field1))'}>}Value)

what I notice in your examples is that there are different notations.

your first Expression Show upper-/lower case

your second Expression Show lower case (date_key).

this must natch exactly your fieldname!

can you post example qvw?

[nazaninslp]

Dear Arvind

it returns zero value for each column

please find my QV file in attachment in above.

Thank you

[nazaninslp]

Dear Rudolf

I've tried it, but didn't work.

please find my example above.

I attached that.

Than you

[Anonymous · Accepted solution]

I checked your qvw and changed youzr Expression to

=sum({<DATE_KEY={"$(=Date(max(DATE_KEY),'YYYY-MM-DD'))"}>} NEW_SUBSCRIPTION_COUNT)

I cannot upload yourt qvw /company policy)

[nazaninslp]

Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu