topic Re: Straight table question in QlikView

Straight table question

Thu, 12 Dec 2013 19:27:27 GMT

Good afternoon,

One column of my straight table can contain duplicate rows. I have the table sorted on that row. Is it possible to have the value displayed for only the first record where each value occurs?

Thanks in advance.

Re: Straight table question

Thu, 12 Dec 2013 19:29:52 GMT

Maybe you could add a row count and only include the data when row count =1

Re: Straight table question

Anonymous — Thu, 12 Dec 2013 19:43:57 GMT

Randy

The distinct() function may be of use to you.

But you need to consider what end result you are hoping to achieve, if you wish to ignore duplicates on that column then you need to decide what to do with other columns you wish to display :

Average ?
Sum ?
First value ?
................ ?

Also you may wish to do things in the load script or maybe in the dashboard.

As the old saying goes:

If you don't know where you are heading, then you'll end up where you are going

Best Regards, Bill

Re: Straight table question

Thu, 12 Dec 2013 20:06:12 GMT

Try the ABOVE function

= IF(FieldName <> Above(FieldName), FieldName, '')

Re: Straight table question

Thu, 12 Dec 2013 22:26:49 GMT

Thanks for all of the suggestions.

Dalton's, would your check be implemented within the Enable Conditional setting at the dimension, or somewhere else?

Thanks.

Re: Straight table question

Thu, 12 Dec 2013 23:38:06 GMT

Sorry ... that's the actual Expression to use. Instead of just using the FieldName (such as Manager name) this expressions says "If the current value I would output doesn't equal the line above then go ahead and output their name, but if Bob Smith is already listed right above leave this cell blank.