topic Count Function not working in QlikView

Count Function not working

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

Dear Sir/Madam

Please help to explain why count function is not working in attached file.

Thank you,

Tracy

Re: Count Function not working

Kushal_Chawda — Mon, 23 May 2016 06:14:09 GMT

What is the expression used? what is the output you need? I am not able to open QVW as I don't have qlikview in my system

Re: Count Function not working

ajsjoshua — Mon, 23 May 2016 06:14:43 GMT

Hi,

share ur expression

Re: Count Function not working

MindaugasBacius — Mon, 23 May 2016 06:19:50 GMT

//CrossTable(Factors, Data, 3)
LOAD Badge,
     Date,
     #Visits,
     Issue,
     [Follow Up]
FROM

(ooxml, embedded labels, table is Sheet1);

Do not use CrossTable statement and you will get the correct result:

Re: Count Function not working

qlikview979 — Mon, 23 May 2016 06:41:56 GMT

Hi,

please finf the attached Qvw.

Try like this

T1:

LOAD Badge,

Date,

#Visits,

Issue,

[Follow Up]

FROM

(ooxml, embedded labels, table is Sheet1);

Dimension:-Badge

Expression:-Count( #Visits)

Re: Count Function not working

shmkmr90 — Mon, 23 May 2016 06:52:04 GMT

The data loaded in the qvw and the xls file is not same, the count(#Visits) is working fine according to the data loaded. please check with the source data.

Re: Count Function not working

Anil_Babu_Samineni — Mon, 23 May 2016 06:59:10 GMT

Tracy,

Try to upload expected o/p also. So that, Community can help you or else getting trouble to find your output ....

Re: Count Function not working

Mon, 23 May 2016 07:02:50 GMT

find attached qvw.