topic Re: Display last date values in straight table in QlikView

Display last date values in straight table

nazaninslp — Tue, 11 Sep 2018 06:20:24 GMT

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 — Tue, 11 Sep 2018 06:31:25 GMT

Hi NAzanin,

Please try below:

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

Thanks,

Arvind Patil

Anonymous — Tue, 11 Sep 2018 06:32:15 GMT

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 — Tue, 11 Sep 2018 06:49:31 GMT

Dear Arvind

it returns zero value for each column

please find my QV file in attachment in above.

Thank you

nazaninslp — Tue, 11 Sep 2018 06:52:42 GMT

Dear Rudolf

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

please find my example above.

I attached that.

Than you

Anonymous — Tue, 11 Sep 2018 07:00:24 GMT

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 — Tue, 11 Sep 2018 11:16:17 GMT

Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu