topic Re: miximum date value where a field a table is not null in QlikView

miximum date value where a field a table is not null

absekrafi — Fri, 20 Nov 2020 18:58:42 GMT

Hi Qlikview community,

I have a table containing stock values of materials.

I want to show the Max (date) where the QTE_STOCK_MP field is not null.

I tried the expression below but it didn't work.

Could you please help me out?

={1<PROD_MP={1},DATE_TRANS=Max(DATE_TRANS) where QTE_STOCK_MP <>0}

Thank you in advance

QFabian — Fri, 13 Nov 2020 14:46:14 GMT

Hi, i feel that something else is missing in your expression, but here you have an exmple :

Max(if(not isnull(QTE_STOCK_MP ),DATE_TRANS))

absekrafi — Fri, 13 Nov 2020 15:16:29 GMT

Hi QFabian,

With this expression I have the stock date of 1 product only. I have 4 products with different stock dates

MayilVahanan — Mon, 16 Nov 2020 04:13:59 GMT

Hi @absekrafi
Try like below

Aggr(Max(if(not isnull(QTE_STOCK_MP ),DATE_TRANS)),Product)
or

Max(Aggr(if(not isnull(QTE_STOCK_MP ),DATE_TRANS),Product,DATE_TRANS))

absekrafi — Mon, 16 Nov 2020 08:33:15 GMT

Hi Mayil,

Thank you very much. Your solution worked.

Best regards,

absekrafi