Discussion board where members can get started with Qlik Sense.
How to use the variable in the calculated field. I need the Distinct count result based on ID and Data like table
Use Left Join
Left Join (TableName)
Count(ID) as Count
Group By ID, Name, Data;
View solution in original post
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)
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
@kppiee Are you using QlikView or Qlik Sense? I would like to move this into the correct product forum. Thank you.
You want to do that in the script?
Yes, if it possible from script
if I reload the data than the calculated field will remain or delete?
It will remain as long as the Left Join exists 🙂