topic Re: HIDE OBJECT in QlikView

HIDE OBJECT

adiarnon — Tue, 13 Sep 2016 06:57:46 GMT

HI,

i want to hide object base on condition

the condition should be-

i should see the object im the current selection is empty

if the the curren selection have field - "employee","department","division"

if one or more of those fields and only those fields are selected i should see the object.

if a selection made on any othe field i want to hide the object.

how can i do it?

adi

Re: HIDE OBJECT

Peter_Cammaert — Tue, 13 Sep 2016 07:00:55 GMT

Create a big conditional show expression for this object that checks whether anything is selected in any of the remaining fields at all. You can use GetSelectedCount() to do that.

Re: HIDE OBJECT

jonathandienst — Tue, 13 Sep 2016 07:09:39 GMT

Its easy to do the first part of your requirement- the show condition would be

=GetSelectedCount(employee)

or GetSelectedCount(department)

or GetSelectedCount(division)

To hide the object when any other selection made is more complicated. You could try

=(GetSelectedCount(employee)

or GetSelectedCount(department)

or GetSelectedCount(division))

and GetSelectedCount(otherfield1) = 0

and GetSelectedCount(otherfield2) = 0

and GetSelectedCount(otherfield3) = 0

...and so on

You will have to list all the other selectable fields in this expression.

Re: HIDE OBJECT

adiarnon — Tue, 13 Sep 2016 07:18:02 GMT

but i have alot of other fields

Re: HIDE OBJECT

robert_mika — Tue, 13 Sep 2016 07:20:23 GMT

in Conditional Show use:

FindOneOf('department', GetCurrentSelections(Con))=1

FindOneOf('employee',GetCurrentSelections(Con))=1

or FindOneOf('division',GetCurrentSelections(Con))=1

Re: HIDE OBJECT

sasikanth — Tue, 13 Sep 2016 07:21:54 GMT

HI,

Try This

Chart Properties-->Layout-->Show->Condition

len(GetCurrentSelections())=0 OR GetSelectedCount(employee)>0 OR GetSelectedCount(department)>0 OR GetSelectedCount(division)>0

Re: HIDE OBJECT

jonathandienst — Tue, 13 Sep 2016 07:23:56 GMT

Here's a different take that removes the need to list all the fields in the expression:

=(GetSelectedCount(employee)

or GetSelectedCount(department)

or GetSelectedCount(division))

And Alt(SubStringCount(GetCurrentSelections('|', '','', 0), '|') + 1, 0) <= RangeSum(

If(GetSelectedCount(employee), 1),

If(GetSelectedCount(department), 1),

If(GetSelectedCount(division), 1)

)

This counts the total number of field selections (the Alt(SubStringCount(GetCurrentSelections('|', '','', 0), '|') + 1, 0) part and counts the number of the employee/department\division fields selected. If another field has selections, then this condition should fail.

Re: HIDE OBJECT

adiarnon — Tue, 13 Sep 2016 07:25:49 GMT

but if a selection made on any othe field i want to hide the object.

Re: HIDE OBJECT

adiarnon — Tue, 13 Sep 2016 07:27:36 GMT

but if a selection made on any other field i want to hide the object.

like if i have a selection on-

employee and year

i dont want to see the object

Re: HIDE OBJECT

susovan — Tue, 13 Sep 2016 07:36:11 GMT

Hi,

You can also try this attached file.

I have use this expression(=SubStringCount(Concat(Dimension, '|'), 'Division')) in the attached application. !

Re: HIDE OBJECT

Digvijay_Singh — Tue, 13 Sep 2016 07:40:22 GMT

You may try using system field $Field as -

=WildMatch(GetFieldSelections($Field),'*Customer Name*','*Country*','*ChannelId*')

This will show object if listed three fields are selected(any combination), if rest of the fields are selected, condition will be false.

Re: HIDE OBJECT

sasikanth — Tue, 13 Sep 2016 07:42:32 GMT

Other than the specified conditions if you select any filter it will be hided ..

Re: HIDE OBJECT

adiarnon — Tue, 13 Sep 2016 13:14:54 GMT

i found a solution-

=if(isnull(SubStringCount( GetCurrentSelections(':', ',', '@', 100), ':')+1),1,
if( SubStringCount( GetCurrentSelections(':', ',', '@', 100), ':')+1>
(WildMatch(getcurrentselections (':', '=', ';', 0 ),'*employee=*')
+WildMatch(getcurrentselections (':', '=', ';', 0 ),'*department=*')
+WildMatch(getcurrentselections (':', '=', ';', 0 ),'*division')),0,1))