Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

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


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.

Partner - Creator III
Partner - Creator III

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.