topic Re: 2 statements within set analysis not counting both statements in QlikView

2 statements within set analysis not counting both statements

helen_pip — Tue, 14 Jan 2014 16:05:26 GMT

Hello

I was wondering if someone could kidnly help me

I have some set analysis eith 2 statements within it

The statement will only count one or the other, and not both together. Could someone kindly cast an eye over my code and let me know why I only ever get either a count for Today's date or a count for when the data source is MAIN_BREACHES

=Count({<data_source_breaches={'MAIN_BREACHES'}>}{<QuarterlyBreaches_End_Date={"$(=Date(Now()))"}>} QuarterlyBreaches_Attendance_ID)

Kind Regards

Helen

Re: 2 statements within set analysis not counting both statements

Nicole-Smith — Tue, 14 Jan 2014 16:12:33 GMT

=Count({<data_source_breaches={'MAIN_BREACHES'}, QuarterlyBreaches_End_Date={"$(=Date(Now()))"}>} QuarterlyBreaches_Attendance_ID)

Re: 2 statements within set analysis not counting both statements

atafsson — Tue, 14 Jan 2014 16:16:37 GMT

Hi Helen,

Type your SET-analysis like this instead:

=Count({<data_source_breaches={'MAIN_BREACHES'}, QuarterlyBreaches_End_Date={"$(=Date(Now()))"}>}QuarterlyBreaches_Attendance_ID)

You don't need the " {< >} " between every statement in the set-analysis. If you have more than one filter in the set-analysis just type " , " between them.

Sum({<Field1 = {'Datafield1'}, Field2 = {'Datafield2'}, Field3 = {'Datafield3'}>}Sales)

Regards

Axel

Re: 2 statements within set analysis not counting both statements

Tue, 14 Jan 2014 16:17:44 GMT

Hi Helen,

Do you mind trying this formula

=Count({<data_source_breaches={'MAIN_BREACHES'}, QuarterlyBreaches_End_Date ={"=$(=Date(Now()))"}>}

QuarterlyBreaches_Attendance_ID)

I just included comma between the two parameters which would act as AND (both needs to be true) and also a '=' before $ when calculating today's date.

Hope it helps.

Thanks

Re: 2 statements within set analysis not counting both statements

jaimeaguilar — Tue, 14 Jan 2014 16:25:18 GMT

Hi,

try with this in order to get a union of both sets of data:

=Count({<data_source_breaches={'MAIN_BREACHES'}> + <QuarterlyBreaches_End_Date={"$(=Date(Now()))"}>}QuarterlyBreaches_Attendance_ID)

regards

Re: 2 statements within set analysis not counting both statements

helen_pip — Wed, 15 Jan 2014 12:17:14 GMT

Hello

Thank you very much for your help

This works a treat for me

Thanks

Helen