topic Conditional 'In' with multiple values in QlikView

Conditional 'In' with multiple values

Thu, 16 Jul 2015 14:17:41 GMT

So i want to make a condition for a line on a graph. I have created inline dimensions for the names (geographies) and want to say that if that particular value is selected (alone or in conjunction with other values) the line will be shown.

Lets say I have:

bronx, albany, hartford as the Geographies

I select bronx, bronx shows.

I select bronx and albany, both show

I select all three, then all three sown

how do i accomplish this??

Thank you

Re: Conditional 'In' with multiple values

Peter_Cammaert — Thu, 16 Jul 2015 14:22:52 GMT

Is it ok that if nothing is relly selected (nothing in green, all in white), then all lines are shown?

Then add "geographies" as a second dimension to your line graph. The legend that now appears will tell you which line corresponds to which geography. Only selected geographies will draw lines.

Peter

Re: Conditional 'In' with multiple values

Thu, 16 Jul 2015 14:27:02 GMT

yes it is okay if nothing is selected, then all lines are displayed.

So the conditions i want are on the lines, which are expressions. How could this work as a dimension??

Re: Conditional 'In' with multiple values

swuehl — Thu, 16 Jul 2015 14:30:28 GMT

If you can't use your Geographie values as a second dimension, i.e. it's an unlinked data island, you can still use conditional expressions. There is an ad-hoc report demo in 'what's new in QV11' demo app showing this approach.

Re: Conditional 'In' with multiple values

Thu, 16 Jul 2015 20:00:02 GMT

Okay this was very helpful - thank you.

So i am going to use a 'substringcount(concat))' and i would like to add in other fields and values into the condition - how could i put in an 'if' statements coupled with the substringcount(concat)??

Re: Conditional 'In' with multiple values

swuehl — Thu, 16 Jul 2015 21:47:35 GMT

The expression should evaluate to false (0) if you want to hide the expression / line or true (-1 (or any other value different from zero). Use AND / OR to build more complex boolean logic

Something like

=SubstringCount(Concat(Geographie,'|'), 'bronx') AND (Sum(OtherField) > 100 OR GetSelectedCount(TriggerField) )

Re: Conditional 'In' with multiple values

Fri, 17 Jul 2015 13:32:34 GMT

so i am using this string:

= SubStringCount(Concat(%_NewEnglandTerrNo, '|'), 1)

and it equates to true no matter what...am i missing something??

Re: Conditional 'In' with multiple values

swuehl — Fri, 17 Jul 2015 15:11:43 GMT

What does

=concat(%_NewEnglandTerrNo, '|')

return in a text box, when you are selecting a value other than 1 (try 2) in that field?

Re: Conditional 'In' with multiple values

Fri, 17 Jul 2015 15:23:41 GMT

concat(%_NewEnglandTerrNo, '|') returns 1|2|3|4|5|6|7

so how do i say that if '1' is in the string at all, return it?? wildmatch does not seem to be working:

= if(wildmatch(Concat(%_NewEnglandTerrNo, '|') ,'*1*'),1,0)

Re: Conditional 'In' with multiple values

Fri, 17 Jul 2015 15:27:07 GMT

my issue is that concat(%_NewEnglandTerrNo, '|') returns 1|2|3|4|5|6|7 no matter my selections.

i want it sch that if i select 2,3,4, then i would get 2|3|4

any ideas??

Re: Conditional 'In' with multiple values

swuehl — Fri, 17 Jul 2015 18:31:01 GMT

Yes, lots of ideas. But I don't know enough about your data model.

When you do a selection in %_NewEnglandTerrNo, I would assume that this will definitely filter your concat() result accordingly. Are you using alternate states? Or are you selecting in a different field, not connected to _NewEnglandTerrNo?

Could you post a small sample QVW?