Generating one line per duplicate value.

[Mitch_Data]

Hi,

Question:

I have a straight table with a lot of values. All the rows are equal except for my dimension "Total Loss"

Total Loss, can either equal Yes, or No. For about 20 values Qlik then creates two lines because they appear multiple times in the dataset, one with Total Loss = Yes, one with Total Loss = No, as it sees them as a seperate entity.

What do I want?

If Total Loss = Yes then I want to only show the Yes value and don't show the No Value. However, the values that have only one line with No or Yes must be showed too.

One dimension that can also be used in the expression is "License Plate" this is also unique.

Thanks in advance.

[rwunderlich · Accepted solution]

I think if you define the Dimension as a calculated Dim:

=MaxString(Total <[License Plate]> [Total Loss])

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Mitch_Data]

Hi Rob,

Thanks for the suggestion, by using the opposite =MinString I got the result that I wanted.
I appreciate your feedback, thank you!

Regards,

Mitchell