topic Set Analysis Problem in QlikView

Set Analysis Problem

Thu, 25 Feb 2010 22:02:24 GMT

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

pbaenen — Thu, 25 Feb 2010 22:57:29 GMT

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

pbaenen — Thu, 25 Feb 2010 23:15:49 GMT

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

Fri, 26 Feb 2010 09:22:47 GMT

Thanks Paul worked a treat