topic Re: Count of text string in Text Box in QlikView

Count of text string in Text Box

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

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.

Re: Count of text string in Text Box

vishsaggi — Sun, 07 Apr 2019 13:16:25 GMT

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

Re: Count of text string in Text Box

ebahadur — Sun, 07 Apr 2019 14:25:41 GMT

Dear Vishsaggi,

No, the data has only text values.

Below screenshot is for your reference.

Thank you for your help.

Re: Count of text string in Text Box

Vegar — Sun, 07 Apr 2019 14:36:05 GMT

Try the expression below
='Total Nationalities '& '-'& TextCount(DISTINCT [Nationality])

Re: Count of text string in Text Box

ebahadur — Mon, 08 Apr 2019 13:09:16 GMT

Thank you very much Vegar. It worked perfectly.