topic Re: Setanalysis with getfieldselection field issues in QlikView

Setanalysis with getfieldselection field issues

Anonymous — Fri, 15 Apr 2016 10:59:30 GMT

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>})

Re: Setanalysis with getfieldselection field issues

sunny_talwar — Fri, 15 Apr 2016 11:01:45 GMT

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

Count(DISTINCT Incident)

Re: Setanalysis with getfieldselection field issues

marcus_sommer — Fri, 15 Apr 2016 11:02:39 GMT

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

- Marcus

Re: Setanalysis with getfieldselection field issues

Anonymous — Fri, 15 Apr 2016 11:02:49 GMT

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

Re: Setanalysis with getfieldselection field issues

Anonymous — Fri, 15 Apr 2016 11:04:25 GMT

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

Re: Setanalysis with getfieldselection field issues

tresB — Fri, 15 Apr 2016 11:06:54 GMT

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

Re: Setanalysis with getfieldselection field issues

marcus_sommer — Fri, 15 Apr 2016 11:11:41 GMT

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

Re: Setanalysis with getfieldselection field issues

swuehl — Fri, 15 Apr 2016 11:11:50 GMT

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) )

Re: Setanalysis with getfieldselection field issues

Anonymous — Fri, 15 Apr 2016 11:12:06 GMT

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

Re: Setanalysis with getfieldselection field issues

Kushal_Chawda — Fri, 15 Apr 2016 11:13:21 GMT

this

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

Re: Setanalysis with getfieldselection field issues

Anonymous — Fri, 15 Apr 2016 11:13:51 GMT

Attaching the screenshot of the syntax. values appear blank. though it states that the expression is ok..normally the formulas should appear in blue but is not the case.

Re: Setanalysis with getfieldselection field issues

sunny_talwar — Fri, 15 Apr 2016 11:14:21 GMT

I have no idea why you need GetFieldSelections here? Can you elaborate the requirement a little more?

Re: Setanalysis with getfieldselection field issues

tresB — Fri, 15 Apr 2016 11:14:49 GMT

There are few bracket issues. Try to copy the expression suggested above and try.

Re: Setanalysis with getfieldselection field issues

tresB — Fri, 15 Apr 2016 11:16:57 GMT

Perhaps, he wants the output on selection only. I.e. - no result until any selection is there.

Re: Setanalysis with getfieldselection field issues

t_chetirbok — Fri, 15 Apr 2016 12:06:39 GMT

I think it should be $ not &

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

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

Re: Setanalysis with getfieldselection field issues

tresB — Fri, 15 Apr 2016 12:10:06 GMT

. Thanks.

Re: Setanalysis with getfieldselection field issues

sunny_talwar — Fri, 15 Apr 2016 12:11:03 GMT

In that case, what about this approach that Stefan mentioned?

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

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

Count(DISTINCT Incident) * RangeMin(Alt(GetSelectedCount(TicketType), 1), 1)

Re: Setanalysis with getfieldselection field issues

Anonymous — Wed, 20 Apr 2016 07:29:10 GMT

It worked the second time when i pasted it. Thanks for the explanation. I learnt something new.

Re: Setanalysis with getfieldselection field issues

Anonymous — Wed, 20 Apr 2016 07:29:32 GMT

Thanks for the syntax.. It worked.

Re: Setanalysis with getfieldselection field issues

Anonymous — Wed, 20 Apr 2016 07:30:12 GMT

It worked with the $ syntax as count(distinct {<Ticket_Type = {"$(=getfieldselections(Ticket_Type))"}>} [Incident])