topic Re: aggregation in QlikView

aggregation

Wed, 25 Nov 2020 16:16:04 GMT

I have a

table:

load

SerialNumber,

testType,

testCode

from.....

vTotalCount=Count({<TEST_TYPE={'A'}>}SERIAL_NUMBER)+Count({<TEST_TYPE={'B'}>}SERIAL_NUMBER)+Count({<TEST_TYPE={'C'}>}SERIAL_NUMBER)

When I am trying to do count(if(testType='A',SerialNumber)/$(vTotalCount)

and selected number and percentage options in number tab in the mekko chart. But I am seeing weird results. Don't know why

Re: aggregation

its_anandrjs — Mon, 25 Sep 2017 16:00:45 GMT

Try this

vTotalCount = Count( {<TEST_TYPE={'A','B','C'}>} SERIAL_NUMBER )

vTotalCount = Count( TOTAL {<TEST_TYPE={'A','B','C'}>} SERIAL_NUMBER )

And this

=count( if ( testType = 'A',SerialNumber ) ) / $(vTotalCount)

Re: aggregation

its_anandrjs — Mon, 25 Sep 2017 16:05:49 GMT

OR direct expression writing with no use of variable

=Count( if ( TEST_TYPE = 'A', SerialNumber ) )

Count( {<TEST_TYPE={'A','B','C'}>} SERIAL_NUMBER )

=NUM( Count( if ( TEST_TYPE = 'A', SerialNumber ) )

Count( {<TEST_TYPE={'A','B','C'}>} SERIAL_NUMBER ) ,'#,##0%')

Or If you have all TEST_TYPE

=NUM( Count( if ( TEST_TYPE = 'A', SerialNumber ) )

Count( {<TEST_TYPE={*}>} SERIAL_NUMBER ) ,'#,##0%')

Re: aggregation

Mon, 25 Sep 2017 16:27:18 GMT

Hi Anand,

Thank you.

I need some thing like

=NUM( Count( if ( TEST_TYPE = 'A', SerialNumber ) )

Count( {<TEST_TYPE={*}>} SERIAL_NUMBER ) ,'#,##0%')

but this expression is not working

Re: aggregation

aarkay29 — Mon, 25 Sep 2017 16:56:08 GMT

try this

=NUM( Count( if ( TEST_TYPE = 'A', SerialNumber ) )

Count( {1<TEST_TYPE={*}>} SERIAL_NUMBER ) ,'#,##0%')

Re: aggregation

its_anandrjs — Mon, 25 Sep 2017 17:02:57 GMT

Share sample data or may be but it should be working because at my end it is working

=NUM( Count( if ( TEST_TYPE = 'A', SerialNumber ) )

Count(TOTAL {<TEST_TYPE={*}>} SERIAL_NUMBER ) ,'#,##0%')

=NUM( Count( if ( TEST_TYPE = 'A', SerialNumber ) )

Count(ALL {<TEST_TYPE={*}>} SERIAL_NUMBER ) ,'#,##0%')