Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
hemeshreddy
Partner
Partner

Excel table to show asis in qlikview

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.

2 Replies
niclaz79
Partner
Partner

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

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.