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.

[anushree1]

But in this case we loose out the info of Companies which does not have a branch, so how can we show that C has zero branches

[Anonymous]

Hi Sanjay,

Yes, I have tried for the same.

1. Select straight Table

2. Dimension: Company

3. Expression: Sum(Branches)

Suggest me, if I m doing right.

If yes, I am not getting the right answer. If not please suggest me the way to do so.

[qlikview979]

Hi sanjay,

  He  said first sheet is input  and expected output in second sheet.

Here small clarification

may be your confused

why  are you  loading here directly output sheet

you have to  load sheet 1 as a input file

regards

[anushree1]

Hi Bijay,

Nagraj is asking you to Change dimension to Branches

[sanjay006]

Bijay !

u need to load the second sheet u are working on first sheet.

I have also tried in straight table and result is same

[Anonymous]

Dear,

you are working on the second sheet.

Input data is the first sheet.

The answer I want or resulted sheet is the 2nd Sheet.

[Anonymous]

But I want the straight table where

Dimension: Company

Expression:  I want the total count of Branches the company has.

Company	Total Branches
A	3
B	2
C	0
D	4
E	2
F	2

[tamilarasu]

Nope. I just want Bijay to try himself. If he is not able to find it, i will surely attach all the steps.

[Anonymous]

Please read my reply ...

I want a straight table where

Dimension is country not Branches

[sanjay006]

but this is not his requirement he just wants to match the company with branch and the show the count.