topic Re: Set analysis count & if with multiple conditions in QlikView

Set analysis count & if with multiple conditions

vikasmahajan — Tue, 16 Feb 2016 10:31:38 GMT

Dear all

I have following expression

=if(GetSelectedCount($(vInititiavtiveHost)) = 0 or count({<$(vInititiavtiveUpdateStatus) = {'Completed', 'Executing'}>} (vInititiavtiveHost)) > 0,0,1)

addtional I want to give OR condition again or count({<$(vInititiavtiveStatus) = {'Completed', 'Executing'}

how to write the correct expression.

Thanks in advance

Vikas

Re: Set analysis count & if with multiple conditions

sunny_talwar — Tue, 16 Feb 2016 10:37:10 GMT

Where exactly are you trying to add this new condition?

Re: Set analysis count & if with multiple conditions

sathishkumar_go — Tue, 16 Feb 2016 10:38:50 GMT

=if(GetSelectedCount($(vInititiavtiveHost)) = 0 or count({<$(vInititiavtiveUpdateStatus) = {'Completed', 'Executing'}>} (vInititiavtiveHost)) > 0 or count({<$(vInititiavtiveStatus) = {'Completed', 'Executing'}>} > 0,0,1)

-Sathish

Re: Set analysis count & if with multiple conditions

vikasmahajan — Tue, 16 Feb 2016 10:39:37 GMT

count({<$(vInititiavtiveStatus) = {'Completed', 'Executing'} this part i want to add in expression with OR condition

Re: Set analysis count & if with multiple conditions

Anonymous — Tue, 16 Feb 2016 10:40:01 GMT

count({<field name={value}>}field name) given the expression

Re: Set analysis count & if with multiple conditions

vikasmahajan — Tue, 16 Feb 2016 10:41:30 GMT

Satish Thanks this i try already but getting error

Re: Set analysis count & if with multiple conditions

sunny_talwar — Tue, 16 Feb 2016 10:43:00 GMT

Still not sure, but may be this:

=If(GetSelectedCount($(vInititiavtiveHost)) = 0 or Count({<$(vInititiavtiveUpdateStatus) = {'Completed', 'Executing'}>+<$(vInititiavtiveStatus) = {'Completed', 'Executing'}>} (vInititiavtiveHost)) > 0,0,1)

Just out of curiosity you have variable on the left hand side of your set modifier, that is working well for you?

Re: Set analysis count & if with multiple conditions

vikasmahajan — Tue, 16 Feb 2016 10:44:34 GMT

First worked Thanks

Vikas

Re: Set analysis count & if with multiple conditions

sunny_talwar — Tue, 16 Feb 2016 10:45:25 GMT

Both are the same expressions. 2nd expression was a question for you

Re: Set analysis count & if with multiple conditions

sathishkumar_go — Tue, 16 Feb 2016 10:57:35 GMT

Hi,

Attach ur application.

-Sathish

Re: Set analysis count & if with multiple conditions

vikasmahajan — Wed, 17 Feb 2016 11:43:22 GMT

Double condition in set analysis