Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

pivot table

Hi Community,

could you help me?

I 'll try to explain my needs.

I created an app in which i'm using a pivot table

APP: EXAMPLE

filter1: no selection

filter2: no selection

                                   measure   

                               col1           col2    col3

dimension row1          aaa          bbb     cccc

dimension row2          aaa          bbb     ccc

dimension row3          aaa          bbb     ccc

all dimension are displayed correctly

BUT IF I USE A FILTER

filter1: customerxxyyzz

filter2: no selection

row related to "no data"  are not rapresented

so that my table is

                                   measure   

                               col1           col2    col3

dimension row1          aaa          bbb     cccc

dimension row3          aaa          bbb     ccc

Exist a way to represent the dimension even in the absence of data?


Fabio  Mazzarelli

5 Replies
ramasaisaksoft
Valued Contributor III

Re: pivot table

Hi Fabio,

i hope you while you created the Pivot table you may be Un-check the option

Include Null Values (Select your chart-->in the properties select your dimension-->Drop down options will come--> below the Label you can find a Check box Include Null Values, do it for all Dimensions and Measures and then you will get your result )


so please check that for each dimension and Expression then you will get the result.

if you didn't get result please post with your sample application with sample data.

fmazzarelli
Contributor III

Re: pivot table

Hi

i checked all check box including Null values.

But values are not null; we are in the presence of data not present because the filter (customer) does not find any data for that dimension.


I would like to be able to create a pivot table with all dimensions as well as images

                               measure   

                               col1           col2    col3

dimension row1          aaa          bbb     cccc

dimension row2

dimension row3          aaa          bbb     ccc


agigliotti
Honored Contributor II

Re: pivot table

please check under "Data handling" if you have the option "Include zero values" checked.

fmazzarelli
Contributor III

Re: pivot table

Hi

i checked all check box including zero values.

But values are not zero; we are in the presence of data not present because the filter (customer) does not find any data for that dimension.


I would like to be able to create a pivot table with all dimensions as well as images

                               measure   

                               col1           col2    col3

dimension row1          aaa          bbb     cccc

dimension row2

dimension row3          aaa          bbb     cc

agigliotti
Honored Contributor II

Re: pivot table

could you post a sample app with mock data and the expected result ?

Community Browser