Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.