Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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...