Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Question with Pivot Tables

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.

pivot.jpg

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_ARTICOLOSETTIMANA2017-282017-272017-262017-252017-242017-23
ABCDE231101

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

COD_ARTICOLOSETTIMANAQTA_IMP
ABCDE2017-282
ABCDE2017-273
ABCDE2017-261
ABCDE2017-251
ABCDE2017-231

here's the db structure

tables.jpg

thanks in advance to everyone!

4 Replies
settu_periasamy
Master III
Master III

Hi,

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

shiveshsingh
Master
Master

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

Anonymous
Not applicable
Author

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 ?

settu_periasamy
Master III
Master III

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