Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

helen_pip
Contributor II

Set analysis - ignoring 2nd set analysis

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

1 Solution

Accepted Solutions

Re: Set analysis - ignoring 2nd set analysis

I would have written:

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

hope it helps

4 Replies

Re: Set analysis - ignoring 2nd set analysis

I would have written:

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

hope it helps

MVP & Luminary
MVP & Luminary

Re: Set analysis - ignoring 2nd set analysis

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)


talk is cheap, supply exceeds demand
helen_pip
Contributor II

Re: Set analysis - ignoring 2nd set analysis

Thank you!

This works perfectly

Thanks very much

helen_pip
Contributor II

Re: Set analysis - ignoring 2nd set analysis

Thanks for your answer

This has helped me

Thanks

Helen