Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
henrybergemann
Creator
Creator

Expression with Where and AND

Hello Members, i got a quite simple Task....but got a bad day...

I want to count the TicketNumbers, where the Display String is new and the TicketArt is a change...but the Syntax wont fit.

count ({<[StateDisplayString] = {'New'}>} and {<[TicketArt]= {'Change'}>} Distinct TicketNumber)

bet its only a minor Problem, but some help would be nice

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Here it is

count ({<[StateDisplayString] = {'New'}, [TicketArt]= {'Change'}>} Distinct TicketNumber)

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

View solution in original post

2 Replies
Anil_Babu_Samineni

Here it is

count ({<[StateDisplayString] = {'New'}, [TicketArt]= {'Change'}>} Distinct TicketNumber)

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
henrybergemann
Creator
Creator
Author

Thank you !