topic Re: Selecting 2 Values in QlikView

Selecting 2 Values

azmeerrehan — Wed, 08 Aug 2018 02:57:45 GMT

I have a Field called "Field A" with values as "Status A", "Status B" and "Complete C".

I have a text object with a expression If(Mid(Field_A,1,6)='Status',1,0). This works If I select one of the "Status" Values , but when I select both Status Values it goes to 0, I want that weather a user selects "Status A" or "Status B" or Both it should always give me value 1.

Attached please find the sample

Re: Selecting 2 Values

sibin_jacob — Wed, 08 Aug 2018 03:10:23 GMT

Use this formula

=if(Substringcount(concat(Field_A,'|'),'Status')>0,1,0)

Re: Selecting 2 Values

azmeerrehan — Wed, 08 Aug 2018 03:17:01 GMT

It works Partially, means, It still gives me one If I have nothing selected. I expect 0 if nothing is selected

Re: Selecting 2 Values

sibin_jacob — Wed, 08 Aug 2018 03:22:11 GMT

Please use this one

=if(GetSelectedCount(Field_A)>0,

if(Substringcount(concat(Field_A,'|'),'Status')>0,1,0),0)

Re: Selecting 2 Values

azmeerrehan — Wed, 08 Aug 2018 03:32:50 GMT

Now ir works fine, but I am trying to use this as a Conditional Filed show in Dimension of Straight table , but it doesnt work there . What am I missing there

Re: Selecting 2 Values

sibin_jacob — Wed, 08 Aug 2018 03:40:05 GMT

The above formula will work in 'Enable conditional' option also.

Can you please share little more details on your requirement?

What is your dimension? how you need to enable the dimension?

Re: Selecting 2 Values

arvind1494 — Wed, 08 Aug 2018 06:19:31 GMT

=if(getselectedcount(Field_A)>0 and GetFieldSelections (Field_A)<>'Complete C',1,0)