topic Re: conditional show in QlikView

conditional show

Tue, 23 Dec 2014 21:33:13 GMT

Hi all

I want to show a slider when a field of a list box selected and hide when it is unselected how can do this?

like in image (if cus10 select/unselect the last slider show/hide)

thanks

Re: conditional show

its_anandrjs — Tue, 23 Dec 2014 21:39:43 GMT

Hi,

In the Layout properties of the slider write

=GetSelectedCount(YourListboxfieldNamehere)=1

Ex:-

=GetSelectedCount(CustomerName)=1

Regards

Anand

Re: conditional show

Tue, 23 Dec 2014 21:45:09 GMT

dear Anand

I write this bit it would error

=GetSelectedCount(CUS10)=1

Re: conditional show

Wed, 24 Dec 2014 07:12:26 GMT

Hi,

Is CUS10 is field name or value of any field?

Regards

Re: conditional show

Wed, 24 Dec 2014 07:41:55 GMT

hope this helps you,find sample in attachment

Re: conditional show

Wed, 24 Dec 2014 07:48:28 GMT

try this

=getselectedcount(listboxname)>=1 in layout tab >conditional> write this condition

Re: conditional show

vikasmahajan — Wed, 24 Dec 2014 07:55:01 GMT

Hope this helps you.

Vikas

Re: conditional show

Wed, 24 Dec 2014 09:06:46 GMT

Dear Bhawna Gupta

actually it would be correct but not something that I wanted

I want to remove slider when it unselected otherwise show it

for example when select cus1 , cus2 and cus10

show 3 slider

thanks

Re: conditional show

Wed, 24 Dec 2014 09:12:52 GMT

Its field name

Re: conditional show

Wed, 24 Dec 2014 09:21:24 GMT

=getfieldselections(fieldname)>=1 > in layout > conditional

Re: conditional show

Wed, 24 Dec 2014 20:06:07 GMT

Dear Bhawna

I dont catch the solution to the problem

thanks

Re: conditional show

Thu, 25 Dec 2014 03:22:52 GMT

Hi Hossein,

Can you try the below (write it in the Conditional property of the slider):

=GetSelectedCount(WriteHereTheFieldNameAsInScript) > 0 and SubStringCount(';' & Concat(WriteHereTheFieldNameAsInScript, ';') & ';', ';WriteHereTheValueRequiredToShowTheSlider;') = 1

For example:

=GetSelectedCount(Customer) > 0 and SubStringCount(';' & Concat(Customer, ';') & ';', ';CUS10;') = 1

Re: conditional show

Thu, 25 Dec 2014 06:41:34 GMT

Hi Jp_bakhache

It was exactly that I wanted

can you help me how to be good at writing scripts like you.

thanks