This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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 🙂