Count Function not working

[tracycrown]

Dear Sir/Madam

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

Thank you,

Tracy

[Kushal_Chawda]

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

[ajsjoshua]

Hi,

share ur expression

[MindaugasBacius · Accepted solution]

//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:

[qlikview979]

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)

[shmkmr90]

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.

[Anil_Babu_Samineni]

Tracy,

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

[#8]

find attached qvw.