topic Re: How to get Button working with 2 conditions in QlikView

How to get Button working with 2 conditions

Mon, 06 Jun 2016 14:56:54 GMT

Hello there,

I try to create a button with an action that it will show the relevent result when condition 1 & 2 both fufilled. But it is not working.

I didn't set up anything under "General".

Under "Actions", I created an new variable called "VariableEvent". I created a value is " ([Date]) = True && [Value] = '1 ".

Condition 1: [Date] is one of my data fields with date format as its value. What I try to do is when the Date field exsit and have value in it (=True), then searching for condition 2.

Condition 2: [Value] only contain '0, 1 and 2'.

I am not sure how to get this work. Can anyone with more experience provide me some hint?

Thanks in advance,

Becky

Re: How to get Button working with 2 conditions

sunny_talwar — Mon, 06 Jun 2016 15:06:52 GMT

May be this:

If(GetSelectedCount(Date) > 0 and Value = 1, .....)

Re: How to get Button working with 2 conditions

Kushal_Chawda — Mon, 06 Jun 2016 15:10:45 GMT

=if(not isnull(Date) and match(Value,'0','1','2'),1,0)

Re: How to get Button working with 2 conditions

Mon, 06 Jun 2016 20:20:24 GMT

Thanks Sunny. There is a error after I typed " ) " at the end of the line.

=if(GetSelectedCount([Date])>0 and [value] = 1)

Re: How to get Button working with 2 conditions

Mon, 06 Jun 2016 20:23:12 GMT

Can you kindly let me know what does this mean?

if (Date) is not null, and when Value match....??

Thanks, Kushal.

Re: How to get Button working with 2 conditions

Qrishna — Mon, 06 Jun 2016 20:24:17 GMT

Please check my post on buttons.

https://community.qlikview.com/docs/DOC-8398

Re: How to get Button working with 2 conditions

sunny_talwar — Mon, 06 Jun 2016 20:58:43 GMT

You did not specify the value you are setting your variable:

If(GetSelectedCount(Date) > 0 and Value = 1, 1)

Replace 1 with whatever value you want in place of 1 when the statement is true