Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
ebahadur
Contributor II
Contributor II

Count of text string in Text Box

Dear All,

In my Data I have one column where the Nationalities of my staff are mentioned.

I need to count these all nationalities in a text box.

Currently I am using this : ='Total Nationalities '& '-'& TextCount([Nationality])

But I am getting Total count of all the records using this expression.

Thank you so much.

4 Replies
vishsaggi
Champion III
Champion III

Can you share some sample dataset and your expected output? Do you have any alpha-numeric values in this field? May be try like SUM(IF(ISTEXT(Nationality), 1,0))
ebahadur
Contributor II
Contributor II

Dear Vishsaggi,

No, the data has only text values.

Below screenshot is for your reference.

Thank you for your help.

nationality.JPG

Vegar
Partner
Partner

Try the expression below
='Total Nationalities '& '-'& TextCount(DISTINCT [Nationality])
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
ebahadur
Contributor II
Contributor II

Thank you very much Vegar. It worked perfectly.