Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

count with multiple conditions based on list box

AppGroup1Group2
0001AA
0002BB
0003AB
0004CC
0005A
0006BA
.........

List Box (Group2)
A
B
C

Hi masters! I am trying to create a count if with multiple conditions having one of those conditions based on the selected field of the list box.

The conditions should be as following:

vSelectedField = GetFieldSelections(Group2,',')

Group1 <> ''    (not blank)

Group1 = Group2

Group1 = $(=vSelectedField)

something like this:

=count({1<Group1 -= {''}, Group1 = p(Group2), Group1=$(=vSelectedField)}>}App)

Thanks!

1 Solution

Accepted Solutions
Highlighted

May be this

Count(DISTINCT {<App = {"=Len(Trim(Group)) > 0 and Group1 = Group2"}>}App)

View solution in original post

2 Replies
Highlighted

May be this

Count(DISTINCT {<App = {"=Len(Trim(Group)) > 0 and Group1 = Group2"}>}App)

View solution in original post

Highlighted
Contributor III
Contributor III

Thanks Sunny!