topic Re: Creating Pivot table with out expression in Qliksense in App Development

Creating Pivot table with out expression in Qliksense

Anonymous — Fri, 24 Aug 2018 05:12:31 GMT

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.

21-3-2018

22-3-2018

23-3-2018

BXXPP

BXXPP1

BX1213

AJDJK

INSEE1

AJDJK

R2134

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

Re: Creating Pivot table with out expression in Qliksense

andrey_krylov — Fri, 24 Aug 2018 05:25:00 GMT

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

Re: Creating Pivot table with out expression in Qliksense

Anonymous — Fri, 24 Aug 2018 06:11:54 GMT

Hi Andrey,

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

Re: Creating Pivot table with out expression in Qliksense

ogautier62 — Fri, 24 Aug 2018 07:23:38 GMT

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

Re: Creating Pivot table with out expression in Qliksense

Anonymous — Fri, 24 Aug 2018 08:51:58 GMT

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