Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tracycrown
Creator III
Creator III

Count Function not working

Dear Sir/Madam

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

Thank you,

Tracy

1 Solution

Accepted Solutions
MindaugasBacius
Partner
Partner

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

Screenshot_1.jpg

View solution in original post

7 Replies
Kush
MVP
MVP

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
Specialist
Specialist

Hi,

share ur expression

MindaugasBacius
Partner
Partner

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

Screenshot_1.jpg

View solution in original post

qlikview979
Specialist
Specialist

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
Contributor III
Contributor III

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 ....

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable

find attached qvw.