Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If function in expression, duplicating lines

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.

3 Replies
puttemans
Specialist
Specialist

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
Partner
Partner

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);