How to show duplicate cells?

Breezy — Wed, 07 Dec 2016 15:40:05 GMT

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

Re: How to show duplicate cells?

m_woolf — Wed, 07 Dec 2016 17:28:46 GMT

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.

topic Re: How to show duplicate cells? in QlikView

How to show duplicate cells?

Re: How to show duplicate cells?