Displaying String in Qliksense Pivot Table.

[Anonymous]

Hi Community,

I am trying to Display Six digit String ID in Qliksense 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 is 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

Thanks in Advance...

[petter]

How is your data model and fields? Could you also share with us some sample data in the relevant tables and fields from the data model?

[Anonymous]

Hi Peter,,

Thanks for the Quick response

Now i am using only one file which contains File Date, String ID and Chassis ID and Some other fields which i am not using.

PFA, Sample Data file.

!

[petter]

Can't see any attachments ...

[Anonymous]

Hi Petter,

PFA, Sample String data.

Thank you

[petter]

Is it something like this you're looking for:

[Anonymous]

Hi Petter,

Not Exactly, if you Notice in the above Image, on 07/04/2018 Actual string ID was "AAXD3X" Next day it has been replaced by AAX3DX. but the change has been not captured side by side instead, it is coming in New row.

I want to capture that change side by side as mentioned in my first Comment.

Thank you

[Anonymous]

Hi Petter,

Do you have any alternate Solution for this issue ? if their is any please suggest me.

Thank you..!