topic Re: test line in QlikView

tesst

dnowebdn — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I would like to have a solution on the follwing scenario

Re: test line

dnowebdn — Fri, 10 Aug 2018 07:44:38 GMT

any suggestions please

Re: test line

bwisealiahmad — Fri, 10 Aug 2018 08:06:53 GMT

Hi,

I've seen people use Chr(10) for this before, but I couldn't seem to make it work...

Would love to see a solution for this.

I was thinking Replacing (a)'s with Chr(10) might work

Forslag petter-s‌?

Best,

Ali A

Re: test line

petter — Fri, 10 Aug 2018 08:27:25 GMT

As far as I know there is absolutely no way to make the lines break while still having them in a single row in a Qlik table (internal table or UI table). You will have to do something in the load script most probably to break one value consisting of several text lines into rows/records in a detail table connected to the original table also maintaining the order of the lines ... Quite a hack - but it is not too complicated.

You might be able to implement it in expressions in the UI too... but it might be even more of a hack than doing it in the load script and less flexible I guess.

Re: test line

dnowebdn — Fri, 10 Aug 2018 09:00:19 GMT

I have write logic however, I am sharing but it yields duplicate and not giving proper results.

Can you suggest me

Re: test line

rubenmarin — Fri, 10 Aug 2018 09:15:05 GMT

Hi you can try with:

replace(FieldName, '@', chr(13)) as FieldName,

Note that tables won't adjust to the heigh of data, heigh of rows is fixed, so if you set height to 3, it will shows 3 lines height for all records.

Re: test line

dnowebdn — Fri, 10 Aug 2018 09:26:40 GMT

Hi Ruben,

It will remove the symbol but my point is to break the rows after the symbol.

So, can you suggest any such logic please

Re: test line

rubenmarin — Fri, 10 Aug 2018 09:28:16 GMT

replace(FieldName, '@', '@'& chr(13)) as FieldName,

Re: test line

dnowebdn — Fri, 10 Aug 2018 09:45:00 GMT

can you send me if the expression is working as expected please.

Re: test line

dnowebdn — Fri, 10 Aug 2018 17:09:10 GMT

any response please

Re: test line

petter — Fri, 10 Aug 2018 18:41:02 GMT

Here is a solution actually:

T:
LOAD
    Module,
    Team AS Team_,
    Subject AS Subject_
FROM [LIB://DATA/Multiple Lines in Excel Cell into Multiple Rows in Qlik Sense.xlsx]
(ooxml, embedded labels, table is Multiline);


T_Lines:
LOAD
  Module,
  If( Peek('Module')=Module, Peek('R#')+1, 1) AS R#,
  SubField(Team_,Chr(10)) AS Team
RESIDENT
  T;


OUTER JOIN 


LOAD
  Module,
  If( Peek('Module')=Module, Peek('R#')+1, 1) AS R#,
  SubField(Subject_,Chr(10)) AS Subject
RESIDENT
  T;


T_LINES:
NOCONCATENATE LOAD
  Module,
  R#,
  If( IsNull(Team) , '' , Team) AS Team,
  If( IsNull(Subject) , '' , Subject) AS Subject
RESIDENT
  T_Lines
ORDER BY
  Module,R#;


DROP TABLE T_Lines;
DROP FIELDS Team_,Subject_;

Re: test line

dnowebdn — Mon, 13 Aug 2018 15:24:48 GMT

i tried however i coulnot acheive 100% with my data.
can you please help check

Re: tesst

dnowebdn — Mon, 13 Aug 2018 15:26:02 GMT

Forslag petter-s?