topic Re: How can I do GetFieldSelections to work for multiple values? in QlikView

How can I do GetFieldSelections to work for multiple values?

jblomqvist — Sun, 05 Jul 2015 17:35:52 GMT

Hi all,

In a Straight table I a have two expressions.

I also have a List Box called Outcome with two values, Passed and Failed.

Expression 1 calculates when Outcome field has Passed selected.

Expression 2 calculates when Outcome field has Failed selected.

I am doing this using Conditional option in Expressions tab.

For expression 1 its: GetFieldSelections(Outcome)='Passed'

For expression 2 its: GetFieldSelections(Outcome)='Failed'

How can I get both expression 1 and expression 2 fields to show when the user selects both Passed and Failed in the Outcome List Box?

Any suggestions would be great

Re: How can I do GetFieldSelections to work for multiple values?

sunny_talwar — Sun, 05 Jul 2015 17:43:33 GMT

Try this:

Expression1 condtion

SubStringCount(Concat(DISTINCT Outcome, '|'), 'Passed') = 1

Expression2 condtion

SubStringCount(Concat(DISTINCT Outcome, '|'), 'Failed') = 1

HTH

Best,

Sunny

Re: How can I do GetFieldSelections to work for multiple values?

jblomqvist — Sun, 05 Jul 2015 17:50:41 GMT

Hi sunindia,

I still get just one column showing when I select both Passed and Failed as values from the Outcome list box.

How does this expression work so maybe I can fix it?

Re: How can I do GetFieldSelections to work for multiple values?

settu_periasamy — Sun, 05 Jul 2015 17:53:21 GMT

one more solution

Exp1:

GetFieldSelections(Outcome)='Passed' or GetSelectedCount(Outcome)>1

Exp2:

GetFieldSelections(Outcome)='Failed' or GetSelectedCount(Outcome)>1

Re: How can I do GetFieldSelections to work for multiple values?

sunny_talwar — Sun, 05 Jul 2015 17:57:46 GMT

I don't see why it wouldn't work. Please see a sample qvw attached.

HTH

Best,

Sunny

Re: How can I do GetFieldSelections to work for multiple values?

maxgro — Sun, 05 Jul 2015 17:57:49 GMT

exp1 condition

wildmatch(concat(Outcome), '*Passed*')

or this

wildmatch(concat(Outcome), '*Passed*') and GetSelectedCount(Outcome)>0

Re: How can I do GetFieldSelections to work for multiple values?

settu_periasamy — Sun, 05 Jul 2015 17:59:56 GMT

Hi,

sunindia expression is working, may be you can check your outcome data (case sensitive) like passed or Passed.

Re: How can I do GetFieldSelections to work for multiple values?

sunny_talwar — Sun, 05 Jul 2015 18:02:58 GMT

That's true. Case sensitiveness can be resolved by using capitalize function

Expression1 condtion

SubStringCount(Concat(DISTINCT Capitalize(Outcome), '|'), 'Passed') = 1

Expression2 condtion

SubStringCount(Concat(DISTINCT Capitalize(Outcome), '|'), 'Failed') = 1

Re: How can I do GetFieldSelections to work for multiple values?

MarcoWedel — Sun, 05 Jul 2015 21:09:00 GMT

Hi,

another solution could be:

hope this helps

regards

Marco

Re: How can I do GetFieldSelections to work for multiple values?

jblomqvist — Mon, 06 Jul 2015 09:29:12 GMT

Hi guys,

Thank you for your reply. This example is correct however what I realised is my Straight Table is a dimensionless chart.

It is only using expressions and the Horizontal option in Presentation to put labels next to the expression.

Any idea how I can do this with this setup?

Re: How can I do GetFieldSelections to work for multiple values?

sunny_talwar — Mon, 06 Jul 2015 09:57:55 GMT

Like this?

The above table has no dimension and two expressions. PFA the sample qvw for reference.

Best,

Sunny

Re: How can I do GetFieldSelections to work for multiple values?

jblomqvist — Mon, 06 Jul 2015 14:48:55 GMT

Hi Marco,

This is almost there!

How can I get it to work in a way that if nothing is selected in Outcome List Box, neither expression is shown.

Then if someone selects Passed it displays the line for that.

If someone selects Failed it displays that line in the chart.

And if someone selects both it displays both lines.

Any ideas?

Re: How can I do GetFieldSelections to work for multiple values?

sunny_talwar — Mon, 06 Jul 2015 15:02:53 GMT

Try these two conditions:

Exp1: =GetSelectedCount(Outcome) > 0 and WildMatch(GetFieldSelections(Outcome), '*Passed*')

Exp2: =GetSelectedCount(Outcome) > 0 and WildMatch(GetFieldSelections(Outcome),'*Failed*')

Also attaching MarcoWedel‌'s sample with the edits.

HTH

Best,

Sunny

Re: How can I do GetFieldSelections to work for multiple values?

jblomqvist — Mon, 06 Jul 2015 15:25:21 GMT

Hi Sunindia,

Could another filter in the same expression affect it?

I can see your great example working and get the logic. However in my same expression I also have another filter like:

GetFieldSelections(StudentType)='Z1'

StudentType being another list box where it contains Z1 or Z2 as possible values.

What happens once I tried your idea is that it filters fine for Passed, it shows both Passed and Failed if I only select Failed, and if I select both Passed and Failed it shows both. So it seems it has a toggle issue somewhere 😕

The idea being that they must select a student type and Outcome (Passed or Failed or both).

Re: How can I do GetFieldSelections to work for multiple values?

sunny_talwar — Mon, 06 Jul 2015 16:32:32 GMT

Not entirely sure what is the third condition you just added. Do you have a sample you can share? or may be explain it again step by step?

Best,

Sunny

Re: How can I do GetFieldSelections to work for multiple values?

MarcoWedel — Mon, 06 Jul 2015 22:08:27 GMT

to show no expressions if no selections are made, another solution could be:

=Alt(WildMatch(GetFieldSelections(Outcome), '*Passed*'),0)

hope this helps

regards

Marco