Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to use a set identifier for a single field

Hi all,

I have this expression =Count({<LateDisp={'$(v1dayLate)'}, OrdStat={'CONFIRM'},InternalServPfeYn={'N'},InternalServExternalPi={'N'}>}DISTINCT if(FinUnits<OrdUnits, ItemOrd)).

I wanted to use the set identifier "1" only for the first condition LateDisp={'$(v1dayLate)'}. Is that possible? How?

Thank you!

Sofia Vaz

4 Replies
Anil_Babu_Samineni

What does this variable? v1dayLate. May be this?

=Count({<LateDisp={"=Only({1} $(v1dayLate))"}, OrdStat={'CONFIRM'},InternalServPfeYn={'N'},InternalServExternalPi={'N'}>}DISTINCT if(FinUnits<OrdUnits, ItemOrd))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
petter
Partner - Champion III
Partner - Champion III

I think this should work for you:


=Count({1<LateDisp={'$(v1dayLate)'}> * <OrdStat={'CONFIRM'},InternalServPfeYn={'N'},InternalServExternalPi={'N'}>}DISTINCT if(FinUnits<OrdUnits, ItemOrd))

Anonymous
Not applicable
Author

v1dayLate is a date. Thank you for the help but it's not working...

Anonymous
Not applicable
Author

Thank you Petter, but it didn't work...