Calculated field use of Variable

[kppiee]

How to use the variable in the calculated field.  I need the  Distinct count result based on ID and Data like table

ID	Name	Data	Distinct Count(ID,Name)
1	A	KPI	2
1	A	KPI	2
1	A	RI	3
1	A	RI	3
1	A	RI	3
2	B	SP	1
2	B	TS	1

[sunny_talwar]

If you only have ID, Name, and Data as dimension, Count(ID) should be enough... but if you have more dimensions, may be this Count(TOTAL <ID, Name, Data> ID)

[kppiee]

It is the input table with three columns ID, Name and Data. I need to create a new column with  count of ID based on the same data

[Sue_Macaluso]

@kppiee Are you using QlikView or Qlik Sense? I would like to move this into the correct product forum. Thank you.

[kppiee]

QlikSense

[sunny_talwar]

You want to do that in the script?

[kppiee]

Yes, if it possible from script 

[sunny_talwar · Accepted solution]

Use Left Join 

Left Join (TableName)
LOAD ID,
     Name,
     Data,
     Count(ID) as Count
Resident TableName
Group By ID, Name, Data;

[kppiee]

if I reload the data than the calculated field will remain or delete?

[sunny_talwar]

It will remain as long as the Left Join exists 🙂