Countif Function in Qlick View

[Anonymous]

Hi,

I M new to QlickView so can any one help me how will I get the count of

Branches in the straight table of QlikView.

In excel I get the same result by using the formula [ =COUNTIFS($B$2:$B$14,A2) ]

Please find the attachment of excel where there is a table on sheet 1 and wanted the result given on sheet2.

[tresesco]

Try:

Substringcount(Concat(Total Branches&'@' ),Company&'@')

[Anonymous]

Sorry

[tamilarasu]

Sorry Guys. I haven't read the question properly. It's a tricky one.