topic Re: Set analysis - ignoring 2nd set analysis in QlikView

Set analysis - ignoring 2nd set analysis

helen_pip — Tue, 05 Mar 2013 12:59:07 GMT

Hello

I have written some set analysis, but for some reason the second part of the set anaylsis is not working and I just get a total figure, rather than the proportion

Could someone kindly tell me what is potentially worng with my set analysis

Count({<Test={'Date In Time'}>}{<data_source={'Inpatients'}>}ur_number

)

Thanks

Helen

Re: Set analysis - ignoring 2nd set analysis

alexandros17 — Tue, 05 Mar 2013 13:18:37 GMT

I would have written:

Count({$ <Test={'Date In Time'}, data_source={'Inpatients'}>}ur_number)

hope it helps

Re: Set analysis - ignoring 2nd set analysis

Gysbert_Wassenaar — Tue, 05 Mar 2013 13:19:18 GMT

Separate the set modifiers by a comma unless you want to create two sets and subtract,add, intersect or union them. I think you probably just want to use two modifiers like this:

Count({<Test={'Date In Time'},data_source={'Inpatients'}>}ur_number)

Re: Set analysis - ignoring 2nd set analysis

helen_pip — Tue, 05 Mar 2013 13:20:53 GMT

Thank you!

This works perfectly

Thanks very much

Re: Set analysis - ignoring 2nd set analysis

helen_pip — Tue, 05 Mar 2013 13:21:39 GMT

Thanks for your answer

This has helped me

Thanks

Helen