If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am trying to load distinct values of field.
I am using distinct key word but it is still carrying duplicates
What I am doing wrong
LOAD Distinct will only give you one row of each identical complete row of your table. The LOAD SCRIPT below will reduce the source by one row containing A, B, C. The final count of rows will be 3.
LOAD distinct * inline [FieldA, FieldB, FieldCA, B, CAA, B, CAA, BB, CA, B, C];
Load 2,3, from qvd 1--count 21
load 4,5 from qvd2--count 313
load 6,7 from qvd 3--53K
Load 2,3 ,if(4='True',5) as count
The count gets multifold
I'm sorry, but I dont really understand your description. Could you try do describe it using a coulpe of tables and explain your desired output?