topic Re: selecting one field selects two fields with somewhat identical name in QlikView

selecting one field selects two fields with somewhat identical name

manisha_uit — Wed, 15 Jan 2014 07:48:26 GMT

Hi All,

I have a list box where I am populating all the fields from the Fact table using

if ($Table = 'FACT' , $Field)

and I have a straight table where I have taken all these fields but with an Enable condition

So, when the user selects some field from the Listbox, then that field populates all the values in the straight table.

Now, the issue is when I select field like Invoice Line Description, I get Invoice Line Description values and Description values

(Description being another field in the table)

In the straight table enable condition, I am writing:

For Invoice Line Description - Index( chr(39) & if(GetSelectedCount($Field) >= 1,concat($Field, chr(39)&','&chr(39))) & chr(39),'Invoice Line Description')>0

For Description - Index( chr(39) & if(GetSelectedCount($Field) >= 1,concat($Field, chr(39)&','&chr(39))) & chr(39),'Description')>0

Please refer the image for better understanding. The title in the straight table shows correct value i.e, 1 of 133 but data is populated from both the fields

Thanks,

Manisha

Re: selecting one field selects two fields with somewhat identical name

rwunderlich — Wed, 15 Jan 2014 08:10:32 GMT

Your expression is picking up the substring "Description".

A better conditional expression(s) would be:

GetSelectedCount([$Field]) AND sum(if([$Field]=''Invoice Line Description'',1))>0

etc

-Rob

Re: selecting one field selects two fields with somewhat identical name

manisha_uit — Wed, 15 Jan 2014 09:46:39 GMT

Hi Rob,

Thanks for your reply

But the expression which you have shared is also giving both Invoice Line Desc and Desc

Regards,

Manisha

Re: selecting one field selects two fields with somewhat identical name

manisha_uit — Wed, 15 Jan 2014 13:20:13 GMT

Thanks a lot Rob. It worked perfect with a slight change in the expression:

GetSelectedCount([$Field]) AND sum(if([$Field]='Invoice Line Description',1))>0

Thanks,

Manisha