Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Breezy
Creator II
Creator II

How to show duplicate cells?

Hi,

In my table I have multiple rows where my SystemID is the same. In the dashboard, if I make a pie chart showing violations, it is correct and will say '2' for two violations. However, when I make a table to see which SystemID those violations are from, even though they are from the same system, the table only shows me one SystemID. I need that SystemID to appear twice in the table, to represent the two violations it had. I also noticed that the measure I used, Violation, shows as "-" , a null value. However, I have a different value for each of the SystemID that are the same. Clearly Qlik, rather than arbitrarily selecting one Violation value, is showing neither. So I need the Violations (and Rule, etc.) to appear with its corresponding SystemID, when the SystemID does show up twice.

Table 1: SystemViolations

Column 1: SystemID

Column 2: Violation

Column 3: Rule

How can I have my SystemID show up twice, once per violation?


Thank you for your time

1 Reply
m_woolf
Master II
Master II

Add something like this to your script:

rowno() as UNID,

Then add the UNID field to your table. If it is a straight table, you can hide the column.