topic Re: Any button to switch between AND/OR mode? in QlikView

Any button to switch between AND/OR mode?

Thu, 17 Jul 2014 01:46:45 GMT

HI, I just learnt about And mode in Qlikview and found out that I have to use the OR-mode and Exclude at the same time?

Can anyone find a way to do it?

PS:I am a young Qlikview learner, can I get a QVD file in order to understand the method deeply?

Many thanks.

Re: Any button to switch between AND/OR mode?

Thu, 17 Jul 2014 01:57:13 GMT

Hi,

You can go through the below 2 links, they'll surely help (the 2nd one contains demo files):

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/19/and-mode

AND-Mode

Re: Any button to switch between AND/OR mode?

Thu, 17 Jul 2014 02:28:02 GMT

Thanks, that's what I want.

But may I know that can I Change the mode of a particular listbox by a button? If so, how can I do it?

Thanks.

Re: Any button to switch between AND/OR mode?

Thu, 17 Jul 2014 02:32:23 GMT

Once you implement your table as described in the links, then go to the listbox property, under the General tab, the "And mode" option will then be enabled and you can check it.

Re: Any button to switch between AND/OR mode?

Thu, 17 Jul 2014 02:40:57 GMT

Sorry, I may not explain my word clearly.

Since I am not the one using the Application, he doesn't want to or even doesn't know to click And mode from the properties. What I want is to add a new object, letting him to choose whether to use And mode / OR mode. In this case is it possible?

Re: Any button to switch between AND/OR mode?

Thu, 17 Jul 2014 02:53:43 GMT

You can add a macro like below (check API Guide) and call it from a button trigger:

sub switchAndmode

set fld = ActiveDocument.GetField("[Type Here Your And-Mode Field]")

set fp = fld.GetProperties

if fp.CanAnd then

if fp.IsAnd = false then

fp.IsAnd = true

else

fp.IsAnd = false

end if

fld.SetProperties fp

end if

end sub

Re: Any button to switch between AND/OR mode?

Thu, 17 Jul 2014 03:12:59 GMT

Thank you so much

Re: Any button to switch between AND/OR mode?

Thu, 17 Jul 2014 03:25:03 GMT

Glad to have helped

Cheers!

Re: Any button to switch between AND/OR mode?

Anonymous — Thu, 17 Jul 2014 03:45:33 GMT

Hi,

You can also check the blog written by Henric Cronström

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/17/and-or

Thanks