Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

simonmccoy
New Contributor

Default Value Date on a Table

Hi, I have a table built that Im uploading data to daily, it has a Product and a number of units in it. The number of units changes day on day so the Product list changes too. The Products where invventory goes to 0 will stay in the database as it may be refilled.. Im looking for this table to wake up fully as if I have just selected the most recent value date which has the most recent inventory stock updated. meaning that the list will not show all products if there is no inventory that day.

Product List

=Product_Name

Currently have my units calculated as follows:

Aggr(NODISTINCT Sum({<[Value Date]={'$(=Max([Value Date]))'}>} [No. Units]), Manufacturer)

This means that the products with a 0 value are still showing up on the table as

im looking to put a similar value date constraint on the Product_Name list

any help would be appreciated

Thanks

3 Replies
MVP
MVP

Re: Default Value Date on a Table

May be try this

Only({<[Value Date]={"$(=Date(Max([Value Date])))"}>} Aggr(NODISTINCT Sum({<[Value Date]={"$(=Date(Max([Value Date])))"}>} [No. Units]), Manufacturer))

simonmccoy
New Contributor

Re: Default Value Date on a Table

That seems to work great.. Thanks for your help

MVP
MVP

Re: Default Value Date on a Table

No problem at all