Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhaskar_anumand
New Contributor

group by count in expression

Hi,

Pl suggest how to get group by count of Port with IP in Expression.

Example : count(A) =7

   

ipnameport
AC1
AC7
AC8
AC10
AC11
AC13
AC14
BC1
BC2
BC3
BC19
BC22

3 Replies
jubarros
Contributor II

Re: group by count in expression

Hi anumandla:

Try an expression like:


     count({<ip={'A'}>}ip)

     sum({<ip={'A'}>} port)

Best Regards,

Juan P.

Re: group by count in expression

IP in expression? Not sure I understand?

vvira1316
Valued Contributor II

Re: group by count in expression

count({<ip>}port)

I had a duplicated header row in my inline table hence it is showing ip in table line

Community Browser