Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Displaying String in Qliksense Pivot Table.

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 ID03/02/201804/02/201805/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

IDUnique ID03/02/201804/02/201805/02/2018
12457ABX123--
22457CPD421CPD421-
32457BXP521BXP521BXP521
42457-AXB123AXB123
52457--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 ?"

IDUnique ID03/02/201804/02/201805/02/2018
12457ABX123AXB123AXB123
22457CPD421CPD421CDP421
32457BXP521BXP521BXP521

Thanks in Advance...

7 Replies
petter
Partner - Champion III
Partner - Champion III

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
Not applicable
Author

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
Partner - Champion III
Partner - Champion III

Can't see any attachments ...

Anonymous
Not applicable
Author

Hi Petter,

PFA, Sample String data.

Thank you

petter
Partner - Champion III
Partner - Champion III

Is it something like this you're looking for:

2018-09-24 13_39_37-Settings.png

Anonymous
Not applicable
Author

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
Not applicable
Author

Hi Petter,

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

Thank you..!