topic Re: Calculation in QlikView

Calculation

kevbrown — Fri, 20 May 2016 09:59:32 GMT

Why does my expression not work -

=Count(if([Limit Code]='S1' and [E-Coli]='PASS' or

Count(if([Limit Code]='S2 And [E-Coli]='PASS', '1'))))

Thanks

Re: Calculation

tamilarasu — Fri, 20 May 2016 10:03:13 GMT

May be try.

Count({<[Limit Code]={'S1', 'S2'},[E-Coli]={'PASS'}>}[Limit Code])

If this is not what you need, please explain your requirement.

Re: Calculation

Kushal_Chawda — Fri, 20 May 2016 10:03:16 GMT

i think

Count( if( match([Limit Code],'S1' ,'S2') or [E-Coli]='PASS',1))

Re: Calculation

ankit777 — Fri, 20 May 2016 10:03:52 GMT

Try this

Count(

if(

([Limit Code]='S1' and [E-Coli]='PASS') or

([Limit Code]='S2 And [E-Coli]='PASS'),

'1')

)

Re: Calculation

swuehl — Fri, 20 May 2016 10:04:24 GMT

Because your nesting a Count() aggregation function into another aggregation, which is in general not possible.

What do you wan to achieve?

Maybe this?

=Count(

if( ([Limit Code]='S1' and [E-Coli]='PASS') or ( [Limit Code]='S2 And [E-Coli]='PASS'), '1')

)

Re: Calculation

kevbrown — Fri, 20 May 2016 10:20:56 GMT

Thanks, easy as that hey!!

Re: Calculation

kevbrown — Fri, 20 May 2016 11:18:09 GMT

Moving on from that and creating a % I've got this -

=(Sum(if(([Limit Code]='S1' and [Listeria]='PASS') or

([Limit Code]='S2' and [Listeria]='PASS') or

([Limit Code]='D3' and [Listeria]='PASS') or

([Limit Code]='D4' and [Listeria]='PASS') or

([Limit Code]='Group 2' and [Listeria]='PASS') or

([Limit Code]='Group 3' and [Listeria]='PASS')

,'1'))

Sum(if(([Limit Code]='S1' and [Listeria]='FAIL') or

([Limit Code]='S2' and [Listeria]='FAIL') or

([Limit Code]='D3' and [Listeria]='FAIL') or

([Limit Code]='D4' and [Listeria]='FAIL') or

([Limit Code]='Group 2' and [Listeria]='FAIL') or

([Limit Code]='Group 3' and [Listeria]='FAIL') or

([Limit Code]='S1' and [Listeria]='PASS') or

([Limit Code]='S2' and [Listeria]='PASS') or

([Limit Code]='D3' and [Listeria]='PASS') or

([Limit Code]='D4' and [Listeria]='PASS') or

([Limit Code]='Group 2' and [Listeria]='PASS') or

([Limit Code]='Group 3' and [Listeria]='PASS')

,'1')))

but it doesn't work!

Re: Calculation

swuehl — Fri, 20 May 2016 11:25:32 GMT

Doesn't work means no result or wrong result?

I think the very last closing bracket needs to be removed.

Do both aggregations return something on their own?

Re: Calculation

kevbrown — Fri, 20 May 2016 11:30:51 GMT

It just displays '1' on the graph

Yes they work as stand alone calculations

Re: Calculation

swuehl — Fri, 20 May 2016 11:38:24 GMT

They work standalone and returning different numbers per dimensional line?

Have you maybe set the number format to only show integers?

Re: Calculation

kevbrown — Fri, 20 May 2016 11:40:19 GMT

Yes they show different numbers and no they're not set to integers

Re: Calculation

swuehl — Fri, 20 May 2016 11:42:55 GMT

Could you upload a sample QVW / screenshots of your chart?