Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
sofiavaz
Contributor II

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
Partner
Partner

Re: Functions in set expression

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

View solution in original post

2 Replies
Partner
Partner

Re: Functions in set expression

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

View solution in original post

sofiavaz
Contributor II

Re: Functions in set expression

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