Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sofiavaz
Contributor

Functions in set expression

Hi all,

I'm trying to filter a set expression for the maximum InventoryFrozenInventoryDate value... In order to achieve that, I've written this expression:

Sum({<InventoryFrozenInventoryDate={"$=max(InventoryFrozenInventoryDate)"}, InventoryFrozenOrdType-={'PRS'},InventoryFrozenInventoryType={'FINISH'},InventoryFrozenStat={'B'}>}InventoryFrozenTon)

However, it's not working… does anyone knows what I might be doing wrong?

Thank you,

Sofia

1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: Functions in set expression

Sum({<InventoryFrozenInventoryDate={"$(=max(InventoryFrozenInventoryDate))"}, InventoryFrozenOrdType-={'PRS'},InventoryFrozenInventoryType={'FINISH'},InventoryFrozenStat={'B'}>}InventoryFrozenTon)

2 Replies
OmarBenSalem
Esteemed Contributor

Re: Functions in set expression

Sum({<InventoryFrozenInventoryDate={"$(=max(InventoryFrozenInventoryDate))"}, InventoryFrozenOrdType-={'PRS'},InventoryFrozenInventoryType={'FINISH'},InventoryFrozenStat={'B'}>}InventoryFrozenTon)

sofiavaz
Contributor

Re: Functions in set expression

Thank you Omar! It works! What a silly mistake I did...!

Community Browser