Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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 !