Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Problem

I have a problem with set analysis that i am hoping for an answer

I am using this expression and it works

=

count( {1<Siccode= {Construction} >} CaseID )

This counts all Siccodes that are text string construction only.

I want to replace the string Construction with the selected Siccode in a list box

I have tried



=

count( {1<Siccode= {Siccode} >} CaseID )

As I have selected company in another list box the Siccode is filtered but not selected.

Thanks for your help







1 Solution

Accepted Solutions
pbaenen
Contributor III
Contributor III

Syntax would be something like: count( {1<Siccode= {$(=Only(Siccode))} >} CaseID )

View solution in original post

3 Replies
pbaenen
Contributor III
Contributor III

Can users only select one Siccode? If so, try using only(Siccode)

pbaenen
Contributor III
Contributor III

Syntax would be something like: count( {1<Siccode= {$(=Only(Siccode))} >} CaseID )

Not applicable
Author

Thanks Paul worked a treat