Problem with multiple fields joining to one row

Thu, 21 Jun 2012 11:10:23 GMT

Hi!

I´m having a problem how to join values of multiple field into one row. I have 3 different kind of fields which all comes from same SQL sourse with different attributes:

Vastaustapa:

LOAD

if(REPORTMEDIAID='FAX', 'Yes', 'No') as FAX,

if(REPORTMEDIAID='PAPER', 'Yes', 'No') as Paper,

if(REPORTMEDIAID='HL7', 'Yes', 'No') as HL7,

W_KEYID1 as Request_number

;

I´m using Request_number as a dimension in table box. One Request_number can have 'Yes' and 'No' values simultaneously in different fields.

I´m not quite sure how to represent this in one chart correctly because it should show only one row.

FAX	HL7	Paper	Request_number
No	Yes	No	28438
Yes	No	No	28438

There should be only one row containing yes in fields FAX and HL7 an noin Paper.

topic Problem with multiple fields joining to one row in QlikView

Problem with multiple fields joining to one row