topic Expression with Where and AND in QlikView https://community.qlik.com/t5/QlikView/Expression-with-Where-and-AND/m-p/1413892#M815945 <HTML><HEAD></HEAD><BODY><P>Hello Members, i got a quite simple Task....but got a bad day...</P><P>I want to count the TicketNumbers, where the Display String is new and the TicketArt is a change...but the Syntax wont fit.</P><P></P><P>count ({&lt;[StateDisplayString] = {'New'}&gt;} and {&lt;[TicketArt]= {'Change'}&gt;} Distinct TicketNumber)</P><P></P><P>bet its only a minor Problem, but some help would be nice</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT henrybergemann 2020-11-25T16:16:04Z Expression with Where and AND https://community.qlik.com/t5/QlikView/Expression-with-Where-and-AND/m-p/1413892#M815945 <HTML><HEAD></HEAD><BODY><P>Hello Members, i got a quite simple Task....but got a bad day...</P><P>I want to count the TicketNumbers, where the Display String is new and the TicketArt is a change...but the Syntax wont fit.</P><P></P><P>count ({&lt;[StateDisplayString] = {'New'}&gt;} and {&lt;[TicketArt]= {'Change'}&gt;} Distinct TicketNumber)</P><P></P><P>bet its only a minor Problem, but some help would be nice</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-with-Where-and-AND/m-p/1413892#M815945 henrybergemann 2020-11-25T16:16:04Z Re: Expression with Where and AND https://community.qlik.com/t5/QlikView/Expression-with-Where-and-AND/m-p/1413893#M815946 <HTML><HEAD></HEAD><BODY><P>Here it is</P><P>count ({&lt;[StateDisplayString] = {'New'}, [TicketArt]= {'Change'}&gt;} Distinct TicketNumber)</P></BODY></HTML> Thu, 14 Sep 2017 09:42:31 GMT https://community.qlik.com/t5/QlikView/Expression-with-Where-and-AND/m-p/1413893#M815946 Anil_Babu_Samineni 2017-09-14T09:42:31Z Re: Expression with Where and AND https://community.qlik.com/t5/QlikView/Expression-with-Where-and-AND/m-p/1413894#M815947 <HTML><HEAD></HEAD><BODY><P>Thank you !</P></BODY></HTML> Thu, 14 Sep 2017 09:48:48 GMT https://community.qlik.com/t5/QlikView/Expression-with-Where-and-AND/m-p/1413894#M815947 henrybergemann 2017-09-14T09:48:48Z