Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,
Hi Shona
Should the expression just be [Actual Date] and also set Total Mode to No Total on the Expressions tab
Andy
Generic
LOAD Shipment,
[Milestone Description],
[Actual Date]
FROM
[Test expression duplication.xlsx]
(ooxml, embedded labels, table is Sheet1);