How do I show the results of a COUNT(DISTINCT ID) inside a text field in Qlik Sense ?

[wcoleman0908]

Get_KPI:

LOAD count(distinct ID) as vKPI

From [Lib://location/source.qvd] (qvd)

;

Create a Text object to show the variable $(vKPI) value returned.

It is my intent to then share this on a SharePoint webpart along with other KPI variables as requested.

[Lisa_Sun]

Example:

SET vKPI='';

Get_KPI:

LOAD count(distinct ID) as vID
Resident Transactions
;

LET vKPI=peek('vID');

In the text object, you can inset the expression as ='$(vKPI)'
 

[MarcoWedel · Accepted solution]

In your example vKPI is a field rather than a variable.

Can you try just using =vKPI instead of $(vKPI) in your text object?

[Sabrina_V]

Hello,

Like @MarcoWedel  said, vKPI is a field not a variable.

In the text you need to add a measure like this  : sum(vKPI).

If you want to add some descritive, add a measure and type : '<your text> ' & Num(Sum(vKPI),'#,##0.00'  )