topic Re: Countif Function in Qlick View in QlikView

Countif Function in Qlick View

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Countif Function in Qlick View

tamilarasu — Tue, 16 May 2017 07:43:17 GMT

Hi Bijay,

Create straight table and add

Dimension: Branches

Expression: Count(Branches)

Re: Countif Function in Qlick View

qlikview979 — Tue, 16 May 2017 07:47:31 GMT

may be like this

Re: Countif Function in Qlick View

Anonymous — Tue, 16 May 2017 08:18:39 GMT

Hi Mahesh,

If you observe carefully Company A have 3 Branches.

I want the result as given in sheet 2

Re: Countif Function in Qlick View

sanjay006 — Tue, 16 May 2017 08:22:27 GMT

Re: Countif Function in Qlick View

Anonymous — Tue, 16 May 2017 08:26:56 GMT

Yes Sanjay,

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

As downloading features is not available in my network.

Re: Countif Function in Qlick View

sanjay006 — Tue, 16 May 2017 08:38:01 GMT

dimension : Company

expression :sum([Total Branches])

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

Re: Countif Function in Qlick View

tamilarasu — Tue, 16 May 2017 08:40:38 GMT

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

Re: Countif Function in Qlick View

sanjay006 — Tue, 16 May 2017 08:42:45 GMT

Guru

Re: Countif Function in Qlick View

Anonymous — Tue, 16 May 2017 08:45:25 GMT

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.

Re: Countif Function in Qlick View

anushree1 — Tue, 16 May 2017 08:46:50 GMT

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

Re: Countif Function in Qlick View

Anonymous — Tue, 16 May 2017 08:48:25 GMT

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.

Re: Countif Function in Qlick View

qlikview979 — Tue, 16 May 2017 08:48:51 GMT

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

Re: Countif Function in Qlick View

anushree1 — Tue, 16 May 2017 08:48:53 GMT

Hi Bijay,

Nagraj is asking you to Change dimension to Branches

Re: Countif Function in Qlick View

sanjay006 — Tue, 16 May 2017 08:49:03 GMT

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

Re: Countif Function in Qlick View

Anonymous — Tue, 16 May 2017 08:54:00 GMT

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.

Re: Countif Function in Qlick View

Anonymous — Tue, 16 May 2017 08:59:41 GMT

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

Re: Countif Function in Qlick View

tamilarasu — Tue, 16 May 2017 09:08:50 GMT

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

Re: Countif Function in Qlick View

Anonymous — Tue, 16 May 2017 09:10:32 GMT

Please read my reply ...

I want a straight table where

Dimension is country not Branches

Re: Countif Function in Qlick View

sanjay006 — Tue, 16 May 2017 09:12:37 GMT

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