Creating Pivot table with out expression in Qliksense

[Anonymous]

Hi Community,

I am working the pivot table in Qlilsense, I have a data set which contain ID, File Date, Part ID (Fields) now i want to display this data in a pivot table as shown below.

ID	21-3-2018	22-3-2018	23-3-2018
1	BXXPP	BXXPP1	BXXPP1
2	BX1213	BX1213	AJDJK
3	INSEE1	AJDJK	AJDJK
4	R2134	WJBCD	WJBCD

Basically i want to Track the change in PartID's by file date and want to highlight the changed PartID's. so is their any way to achive this requirement in Qliksense ? Please help me guys.

Thanks in Advance

[andrey_krylov]

Maybe just put [Part ID] in expression and remove it from dimensions...

[Anonymous]

Hi Andrey,

Thanks for the reply..! It's not working that way i am getting '-' symbol.

[ogautier62]

Hi,

you surely have sevaral rows same part_id

use maxString(part_id) or only to avoid null value

for change :

use above if it is changes for same days

use before if it is changes for same ID

regards

[Anonymous]

Hi Oiver,

That data which i had posted is dummy data, so basically the source file is generated on daily bases, so lets say in the first generated file is generated on 21-08-2018 in that file for  ID 1, Part-ID is BXPP and in the Next generated file the Part no is changed to AXPP for ID 1 then that change need's to be highlighted. That's y i want to show the data in pivot table keeping File date as Column. and ill write the colour coding for highlight the changed Partno.

Regards,

Vinod