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.

[qlikview979]

Hi,

I have created straight table as per your requirement  in front end like below

Here C count is Zero(0)  that's why its not showing remaining thing is same.

[tyagishaila]

LOAD Company

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD

    Branches as Company,

    Branches

FROM

(ooxml, embedded labels, table is Sheet1);

In Straight Table

Dimension -  Company

Expression -  count(Branches)

[sanjay006]

Nice !

this will work fine.

[sanjay006]

Either u can create a loop or use the expression given by tresesco‌

Expression:

=SubStringCount(Concat (TOTAL Branches&'@'), CompanyCompany&'@'&'@')

Dimension :

Company

[sanjay006]

tresesco‌

[sanjay006]

if u got the ans please close this thread

[Anonymous]

I have 90 thousand data in my data set , so will be it possible to do it in inline method.

I have shared with you all a sample of it..

[tresesco]

bijay.jha‌,

Inline method is shown as an example. It works fine even if you load the data from excel or any other source.

[sanjay006]

Yup 😛

[Anonymous]

It's not working for me, I have done the fallowing steps...

1) SET NullInterpret=' ' ;

2) Dimension: Country

3) Expression : =Substringcount(Concat(Total Branches&'@',Company&'@')