Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
dwhanand
New Contributor II

Non Aggregable data in Pivot Table

Hello,

I have report to show few dimensions with values in Pivot Table

Note : No measures and the dimensions are represented as KPI values with data types as text, number, percentage etc

RawData:

CustomerProductKPI1KPI2KPI3KPI4KPI5KPI6KPI7KPI8KPI9KPI10
X1A10.01AA1%25abc     
X1A20.02BB2%30aabg     
X1A30.01CC5%45hjk     
X2A10.03DD 65ar     
X3A10.05BB 56.5aabg     
X3A21.12CC 62hjk     
X3A31.887BB 78.5aabg     
X3A42.159CC 84hjk     
X5A12.431DD 89.5ar     
X5A32.975BB 100.5aabg     
X5A43.247CC 106hjk     
X5A53.519DD 111.5hjk     

 

Converted the raw data to KPI Names & Values using cross table for displaying in pivot table as 

CustomerProductKPI NameKPI Value
X1A1KPI10.01
X1A1KPI2AA
X1A1KPI31%
X1A1KPI425
X1A1KPI5abc
X1A2KPI10.02
X1A2KPI2BB
X1A2KPI32%
X1A2KPI430
X1A2KPI5aabg
X1A3KPI10.01
X1A3KPI2CC
X1A3KPI35%
X1A3KPI445
X1A3KPI5hjk

 

Expected output:

 A1A2A3A4
 KPI1KPI2KPI3KPI4KPI5KPI1KPI2KPI3KPI4KPI5KPI1KPI2KPI3KPI4KPI5     
X10.01AA1%25abc0.02BB2%30aabg0.01CC5%45hjk     
X21.01AA9%35abc----------     
x30.05BB 56.5aabg1.12CC 62hjk1.887BB 78.5aabg2.159CC 84hjk

 

The challenge is there is no measure used in expression as sum or count etc

This is an urgent requirement and looking for an early help. Thanks in advance.

 

Labels (2)
2 Replies
dwhanand
New Contributor II

Re: Non Aggregable data in Pivot Table

 A1    A2    A3    A4    
 KPI1KPI2KPI3KPI4KPI5KPI1KPI2KPI3KPI4KPI5KPI1KPI2KPI3KPI4KPI5KPI1KPI2KPI3KPI4KPI5
X10.01AA1%25abc0.02BB2%30aabg0.01CC5%45hjk     
X21.01AA9%35abc----------     
x30.05BB 56.5aabg1.12CC 62hjk1.887BB 78.5aabg2.159CC 84hjk
volakakis
New Contributor II

Re: Non Aggregable data in Pivot Table

in the expression in the pivot table try this Text([KPI Value])