Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan
Champion
Champion

Set analysis count & if with multiple conditions

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

1 Solution

Accepted Solutions
sunny_talwar

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?

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

View solution in original post

10 Replies
sunny_talwar

Where exactly are you trying to add this new condition?

sathishkumar_go
Partner
Partner

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

-Sathish

vikasmahajan
Champion
Champion
Author

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

vsudhakar
Creator III
Creator III

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

vikasmahajan
Champion
Champion
Author

Satish Thanks this i try already but getting error

sunny_talwar

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?

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

View solution in original post

vikasmahajan
Champion
Champion
Author

First worked Thanks

Vikas

sunny_talwar

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

sathishkumar_go
Partner
Partner

Hi,

Attach ur application.

-Sathish