Setanalysis with getfieldselection field issues

[Anonymous]

I need help to understand what is going wrong with my syntax of getfield used in conjunction with set analysis

I am trying count the number of tickets when the user selects the field in the list box  titled 'Ticket Type'. I have used the below syntax but it shows an error in the set modifier when i type the below. I am not able to understand what is going wrong with it Can somebody please help me?

count(distinct {<Ticket_Type = {=getfieldselection(Ticket_Type)}Incident>})

[sunny_talwar]

I don't think you need any set analysis here: Have you tried this?

Count(DISTINCT Incident)

[marcus_sommer · Accepted solution]

Try: count({<Ticket_Type = {"$(=getfieldselection(Ticket_Type))"} >} distinct Incident)

- Marcus

[Anonymous]

I need to calculate basis the value selected in the listbox. so when the value is Alerts then the count needs to be updated

[Anonymous]

When i put ' " ' i.e double quotes the gefieldselection does not appear in blue it appear as a text and not as predefined formula..

[tresB]

count(distinct {<Ticket_Type = {"$(=getfieldselections(Ticket_Type))"}>} Incident)

[marcus_sommer]

The double-quotes surrounding an expression within a set analysis are mandatory to be calculated and yes they won't be regognized as an expression from syntax checker then they won't be considered as a nested function inside from another function then this part is mainly a dataset (even if the result comes from an expression).

Update: and have a look on the red chars in Treseco's answer.

- Marcus

[swuehl]

I believe Sunny is right here, or we are missing something else:

=Count(DISTINCT Incident)

should already consider user selections in TicketType. Or if you want to check if there is a single selection:

=If( GetSelectedCount( TicketType)= 1, Count(DISTINCT Incident)  )

[Anonymous]

This is what happens when i use quotes..it all appears in red

[Kushal_Chawda]

this

count({<Ticket_Type = {"=getfieldselections(Ticket_Type)"} >} distinct Incident)