Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)
Hi NAzanin,
Please try below:
sum({<Date_key={"$(=Date(max(<Category>DATE_KEY),'YYYY-MM-DD')))"}>} NEW_SUBSCRIPTION_COUNT)
Thanks,
Arvind Patil
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?
Dear Arvind
it returns zero value for each column
please find my QV file in attachment in above.
Thank you
Dear Rudolf
I've tried it, but didn't work.
please find my example above.
I attached that.
Than you
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)
Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu