topic Re: Highlighting Substring in Qliksense Table box in App Development

Highlighting Substring in Qliksense Table box

Anonymous — Sun, 16 Sep 2018 13:38:01 GMT

Hi Community,

I have a table box as shown below

Uniqe ID	File Date	String ID
2457	03/02/2018	ABX123,CPD4219,BXP521
2457	04/02/2018	AXB123,CPD4219,BXP521
2457	05/02/2018	AXB123,CDP4219,BXP521

Now my requirment is to compair the string ID with the above string ID and Highlight the part of the string which has changed.

Example for the File date 04/02/2018 String ID was ABX123 which has changed to AXB123, so now i want to highlight only AXB123.

Please help me to achive this requirment guys.

Thanks in advance..☺

Re: Highlighting Substring in Qliksense Table box

jonathandienst — Sun, 16 Sep 2018 15:56:23 GMT

If you want to highlight the part that changes, you are out of luck with vanilla Qlik, as that is not possible in a normal QS table.

Look for an extension that allows HTML content in table cells, then you could construct something in the HTML., like wrapping the changed part in <B></B> tags (or DIV tags with a style).

Re: Highlighting Substring in Qliksense Table box

Anonymous — Mon, 17 Sep 2018 04:31:21 GMT

Hi Jonathan,

Thanks for the Quick response

Since above requirement can not achieved, i was trying some different way to achieve the same, Now i had spitted the Above String ID into multiple Six digit code based on delimiter and i am trying to represent it in the pivot table using only(String_ID) as my expression, But my resultant Pivot Table is as shown below.

Unique ID	03/02/2018	04/02/2018	05/02/2018
2457	-	-	-

Since their is no Unique ID's in the pivot table, it showing Null values for all the dates.

so to resolve the above issue i had created unique ID's for for Each String_ID using AutoNumber() as shown below.

AutoNumber("Unique ID"&&Srting_ID) as ID

Now My pivot table Looks like this

ID	Unique ID	03/02/2018	04/02/2018	05/02/2018
1	2457	ABX123	-	-
2	2457	CPD421	CPD421	-
3	2457	BXP521	BXP521	BXP521
4	2457	-	AXB123	AXB123
5	2457	-	-	CDP421

The issue hear is user can not understand which String ID is replaced with what, "So their any way to synchronise String_ID's side by side as Shown below ?"

ID	Unique ID	03/02/2018	04/02/2018	05/02/2018
1	2457	ABX123	AXB123	AXB123
2	2457	CPD421	CPD421	CDP421
3	2457	BXP521	BXP521	BXP521

Thank you

Re: Highlighting Substring in Qliksense Table box

Anonymous — Tue, 18 Sep 2018 04:47:46 GMT

Hi Guys,

Please can anyone help me with this requirement

Thank you.

Re: Highlighting Substring in Qliksense Table box

Anonymous — Tue, 18 Sep 2018 11:29:02 GMT

Hi Community,

Since above requirement can not achieved, i was trying some different way to achieve the same, Now i had splitted the Above String ID into multiple Six digit code based on delimiter and i am trying to represent it in the pivot table using only(String_ID) as my expression, But my resultant Pivot Table is as shown below.

Unique ID	03/02/2018	04/02/2018	05/02/2018
2457	-	-	-

Since their is no Unique ID's in the pivot table, it showing Null values for all the dates.

so to resolve the above issue i had created unique ID's for for Each String_ID using AutoNumber() as shown below.

AutoNumber("Unique ID"&&Srting_ID) as ID

Now My pivot table Looks like this

ID	Unique ID	03/02/2018	04/02/2018	05/02/2018
1	2457	ABX123	-	-
2	2457	CPD421	CPD421	-
3	2457	BXP521	BXP521	BXP521
4	2457	-	AXB123	AXB123
5	2457	-	-	CDP421

The issue hear is user can not understand which String ID is replaced with what, "So their any way to synchronise String_ID's side by side as Shown below ?"

ID	Unique ID	03/02/2018	04/02/2018	05/02/2018
1	2457	ABX123	AXB123	AXB123
2	2457	CPD421	CPD421	CDP421
3	2457	BXP521	BXP521	BXP521

Thank you