topic Re: Question with Pivot Tables in QlikView

Question with Pivot Tables

Anonymous — Tue, 12 Jun 2018 13:39:21 GMT

Hi everyone,

i've got an issue to solve and i need your help. I will use a simple example to explain clearly what i want to get.

I've got a pivot table like the one in the image below.

In this pivot there's only one simple expression "sum(QTA_IMPEGNATO)" which leads to that result.

As you can see, the pivot table has several columns in the format "Year-WeekNumber" (descending order in this case) and in those columns appears the result of the expression sum(QTA_IMPEGNATO).

Obviously, the "2017-24" column is missing because there's no QTA_IMPEGNATO values in that columns.

IS THERE A WAY TO LET THE COLUMN "2017-24" APPEARS EVEN IF IT HAS NO VALUES IN IT ? I WANT TO GET SOMETHING LIKE THIS:

COD_ARTICOLO	SETTIMANA	2017-28	2017-27	2017-26	2017-25	2017-24	2017-23
ABCDE		2	3	1	1	0	1

By the way, the table IMPEGNI has a set of data like these (2017-24 has no values):

COD_ARTICOLO	SETTIMANA	QTA_IMP
ABCDE	2017-28	2
ABCDE	2017-27	3
ABCDE	2017-26	1
ABCDE	2017-25	1
ABCDE	2017-23	1

here's the db structure

thanks in advance to everyone!

Re: Question with Pivot Tables

settu_periasamy — Thu, 14 Jun 2018 18:18:59 GMT

Hi,

Create the Master Calendar and Link with SETTIMANA. Then It will show, even if there is no data.

Re: Question with Pivot Tables

shiveshsingh — Thu, 14 Jun 2018 18:42:08 GMT

As you don't have that date in your data, you need to manually create one master calendar and link with you model

QlikView Master Calendar

Re: Question with Pivot Tables

Anonymous — Thu, 14 Jun 2018 18:57:17 GMT

i already have a Master Calendar in this situation, and it's the one called CALENDARIO, that is linked to IMPEGNI

on the field SETTIMANA.

In that table i have a set of data like these:

SETTIMANA

2017-22

2017-23

2017-24

2017-25

2017-26

2017-27

2017-28

and so on... (the field INDICE is irrilevant...)

Thus i don't know why i can't get the value "2017-24" appear in the pivot.... even if i choose "show all values" in the dimensions options... what am i doing wrong ?

Re: Question with Pivot Tables

settu_periasamy — Thu, 14 Jun 2018 19:20:13 GMT

Did you try to uncheck the 'Suppress Zero values' in the Presentation tab?