topic If function in expression, duplicating lines in QlikView

If function in expression, duplicating lines

Wed, 04 Mar 2015 14:46:29 GMT

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.

Re: If function in expression, duplicating lines

puttemans — Wed, 04 Mar 2015 15:00:09 GMT

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,

Re: If function in expression, duplicating lines

awhitfield — Wed, 04 Mar 2015 15:37:36 GMT

Hi Shona

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

Andy

Re: If function in expression, duplicating lines

robert_mika — Wed, 04 Mar 2015 15:52:26 GMT

Generic

LOAD Shipment,

[Milestone Description],

[Actual Date]

FROM

[Test expression duplication.xlsx]

(ooxml, embedded labels, table is Sheet1);