Excel table to show asis in qlikview

[hemeshreddy]

hi all,

for the excel file how to replicate same in qlik,

while creating qlikview pivot table it is summing two values

please find the attachments.

[niclaz79]

Hi,

Your issue here is that you are expecting the data to be sorted twice on the same column;

1.a, 1.b, Hyd and Bnglr are all in the same column, which gives you only four total rows. In Qlikview you should put 1.a and 1.b in different columns from Hyd and Bnglr, so that you have a combination of 1.a and Hyd and a combination of 1.a and Bnglr that is separate from 1.b Hyd and 1.b Bnglr. Right now they are all treated as the same dimension.

[jaibau1993]

Hi. As Niclas says, you need a new dimension (column) that especifies which concepts are 1.a o 1.b. You need to process a little bit the excel file in order to achieve so. Please, find the attached QV file where I modified the load script.

Bests,

Jaime.