If function in expression, duplicating lines

[#1]

Dear QV Community,

I am trying to "group" an expression for lack of a better term, but my straight table requires that I include the field name as a dimension in order to recognize the if function in my expression.

It's putting the values in different lines, when I actually want a single line, and the various expressions in columns next to one another.

I have attached a sample in a QV model as well as a sample excel sheet of data.

I am sure it's really basic to fix but I've been battling with this for hours.

Any assistance would be greatly appreciated.

[puttemans]

Hi there,

So the excell is what you're looking for, and the QV is what you get? How do you define the date?

Regards,

[awhitfield]

Hi Shona

Should the expression just be [Actual Date] and also set Total Mode to No Total on the Expressions tab

Andy

[robert_mika]

Generic

LOAD Shipment,

     [Milestone Description],

     [Actual Date]

FROM

[Test expression duplication.xlsx]

(ooxml, embedded labels, table is Sheet1);