Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..☺
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).
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
Hi Guys,
Please can anyone help me with this requirement
Thank you.
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