topic Re: Displaying String in Qliksense Pivot Table. in App Development

Displaying String in Qliksense Pivot Table.

Anonymous — Mon, 24 Sep 2018 04:44:44 GMT

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...

Re: Displaying String in Qliksense Pivot Table.

petter — Mon, 24 Sep 2018 08:51:44 GMT

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?

Re: Displaying String in Qliksense Pivot Table.

Anonymous — Mon, 24 Sep 2018 09:31:39 GMT

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.

Re: Displaying String in Qliksense Pivot Table.

petter — Mon, 24 Sep 2018 09:35:14 GMT

Can't see any attachments ...

Re: Displaying String in Qliksense Pivot Table.

Anonymous — Mon, 24 Sep 2018 09:45:01 GMT

Hi Petter,

PFA, Sample String data.

Thank you

Re: Displaying String in Qliksense Pivot Table.

petter — Mon, 24 Sep 2018 11:41:54 GMT

Is it something like this you're looking for:

Re: Displaying String in Qliksense Pivot Table.

Anonymous — Mon, 24 Sep 2018 11:55:23 GMT

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

Re: Displaying String in Qliksense Pivot Table.

Anonymous — Tue, 25 Sep 2018 06:56:10 GMT

Hi Petter,

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

Thank you..!