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.

[tamilarasu]

Hi Bijay,

Create straight table and add

Dimension: Branches

Expression: Count(Branches)

[qlikview979]

may be like this

[Anonymous]

Hi Mahesh,

If you observe carefully Company A have 3 Branches.

I want the result as given in sheet 2

[sanjay006]

[Anonymous]

Yes Sanjay,

This is what I want can you share the expression...

As downloading features is not available in my network.

[sanjay006]

dimension : Company

expression :sum([Total Branches])

if u got the right ans pls mark it as a correct.

[tamilarasu]

Do you want to us to show the result is correct by attaching the screenshot? Did you try what I have suggested?

[sanjay006]

Guru

[Anonymous]

Hi Tamil,

Yes, I have tried for the same.

1. Select straight Table

2. Dimension: Company

3. Expression: Count(Branches)

The result is 1 for all branches.