Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nazaninslp
Contributor III
Contributor III

Display last date values in straight table

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)

1 Solution

Accepted Solutions
Anonymous
Not applicable

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)

View solution in original post

6 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi NAzanin,

Please try below:

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


Thanks,

Arvind Patil

Anonymous
Not applicable

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
Contributor III
Contributor III
Author

Dear Arvind

it returns zero value for each column

please find my QV file in attachment in above.

Thank you

nazaninslp
Contributor III
Contributor III
Author

Dear Rudolf

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

please find my example above.

I attached that.

Than you

Anonymous
Not applicable

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
Contributor III
Contributor III
Author

Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu