topic Re: Set Analysis Expression in QlikView

Set Analysis Expression

helen_pip — Mon, 28 Jul 2014 07:02:47 GMT

Hello

I have an expression which is using set analysis, but it appears not to be working. I have set the criteria so it is only looking at one of my data sources, but it brings back all results, and ignores the fact I have asked it to only bring back results for that particular data set

I have checked the data structure and all seems O.K., so I was wondering if someone could kindly look at the expression, to see if I have written it wrong

=Count({<data_source = {'Out'}>} {diagnostic = {' No Date' , 'Month End'}>}, ID)

Any help would be greatly appreciated

Kind Regards

Helen

Re: Set Analysis Expression

SunilChauhan — Mon, 28 Jul 2014 07:07:35 GMT

dont use , before ID in above expression and use , b/w two conditions see below

Count({<data_source = {'Out'},diagnostic = {' No Date' , 'Month End'}>} ID)

hope this helps

Re: Set Analysis Expression

helen_pip — Mon, 28 Jul 2014 08:18:36 GMT

Hello

Thank you for your suggestion, I have removed the comma (,) and the same problem still applies. Apart from the comma, did you kindly have any other suggestions?

Kind Regards

Helen

Re: Set Analysis Expression

SunilChauhan — Mon, 28 Jul 2014 08:22:53 GMT

syntax could be like

count({<field1={'Value'}, field2={'Value'} >} IDfieldname)

let me know if you have have any Q's

Re: Set Analysis Expression

helen_pip — Mon, 28 Jul 2014 08:27:57 GMT

Hello,

Thank you so much. This has worked......I really appreciate your help

Kind Regards

Helen