Discussion board where members can learn more about Qlik Sense App Development and Usage.
Version - Qlik Sense Nov 2018
I have table with multiple columns with different datatypes.
In this table i have string based column field with many duplicate values. I wish to show only the Distinct or unique values.
This table i'm going to distribute via N printing as Excel output for further analysis.
Distinct function is not working here. i also tried this formula "=concat(distinct(myfield), ',')" this was referred from another old post.
I wish to do this in Qlik sense only.
Any thoughts ?
Thank you for your inputs. I did tried as below with Category as field but got invalid dimension as error.
let me know,
You are using it as a dimension but it should be used as an expression.
But this made me think. If you are using Category as a dimension then this value is repeated because of some other dimensions. For example, if you create a straight table with Category and Product as Dimensions and Sum(Sales) as Expression, then Category values will appear as many times as different products there are in that categories.
If you don't solve your problem, try to give us more details about the table you are triyng to create (dimensions and expressions you want it to have)
Hello @jaibau1993 ,
This is a simple table, i'm not doing any calculation here.
I just wanted to distribute this table in N-printing after filtering some values on numerical fields.
I wanted to create a simple table without duplicate values in category column.
Just like Excel table with rows and columns.
E.g. In Qlik table i have added few different dimensions as a column. In category column i have multiple duplicate values. I want a table without duplicate category values. First/any category from the column should be taken and other rows should be ignored.
Category 1 and 2 duplicates should be removed.
Thank you @Kush
Hi, what is the rule to remove duplicate? Here though there are duplicates for category, but there are different region associated with that. On what basis you decide which category with region you need to keep