Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator 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

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

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

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

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

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

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