Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggregation

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

5 Replies
its_anandrjs

Try this

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


Or


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



And this

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


its_anandrjs

OR direct expression writing with no use of variable

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

/

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

Or

=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%')

Not applicable
Author

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

aarkay29
Specialist
Specialist

try this

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

/

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

its_anandrjs

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%')



Or


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

/

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