Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Removal of hard coding in the set expression

hi,

Can anyone help me to get rid of hard codes.

I have to fetch the count of ticket hops greater than or equal to group_transfers_limit. group_transfers_limit is a field which has the value 3.

=count({$<ResolvedTicket.InAMSScope={'-1'},[Common Ticket Type]={'INCIDENT'},[ResolvedTicket.Group Transfers]={">2"}>}ResolvedTicket.TicketID)

Above expression gives the count of ticket hops greater than 2. I need an expression without hard code and we have to modify the expression using >=group_transfers_limit field in place of hard code.

Could you please modify one more expression to remove hard code,

Thanks in advance.

Smitha

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Try this.

     =count({$<ResolvedTicket.InAMSScope={'-1'},[Common Ticket Type]={'INCIDENT'},[ResolvedTicket.Group Transfers]={"$(=max(group_transfers_limit))"}>}ResolvedTicket.TicketID)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
rajeshvaswani77
Specialist III
Specialist III

Hi Smitha,

Try this.

=count({$<ResolvedTicket.InAMSScope={'-1'},[Common Ticket Type]={'INCIDENT'},[ResolvedTicket.Group Transfers]={'>=group_transfers_limit'}>}ResolvedTicket.TicketID)

or if its possible to have it in a variable then it will be like below.

=count({$<ResolvedTicket.InAMSScope={'-1'},[Common Ticket Type]={'INCIDENT'},[ResolvedTicket.Group Transfers]={'>=$(vgroup_transfers_limit)'}>}ResolvedTicket.TicketID)

thanks,

Rajesh Vaswani