Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Missing values in PivotTable

I would like to add white background where there are  missing values in QS PT.

Unfortunately so far I could not find any solution that works.

(Isnull,0,'' or len() does not work)

Anyone has facing this problem?

In QV you can replace that in Chart Properties, in QS i can not see this option.

Thanks.

1 Solution

Accepted Solutions
MVP
MVP

Re: Missing values in PivotTable

It won't help to play with the expression - it is not evaluated for missing values (at least that's the QV behaviour and I assume QS is the same). So I don't know if what you need is possible in QS without an extension.

10 Replies
darkhorse
Valued Contributor

Re: Missing values in PivotTable

Hello,

That works fine.

BR

Serhan

MVP
MVP

Re: Missing values in PivotTable

It won't help to play with the expression - it is not evaluated for missing values (at least that's the QV behaviour and I assume QS is the same). So I don't know if what you need is possible in QS without an extension.

Re: Missing values in PivotTable

I have got missing data not Null data but thank you for input.

Re: Missing values in PivotTable

Thanks Jonathan,

I hope this will be an option in version 2.0.4 or later

Employee
Employee

Re: Missing values in PivotTable

Hi Robert, just checking / trying to help - something like this?

Before I provide what I did, I wanted to make sure this is what you are talking about?

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Re: Missing values in PivotTable

Sorry I can not share the app but  as you see on the picture value for two categories for 2011 is missing

Capture.PNG

How to add white background to this field and replace the '-' ?

Employee
Employee

Re: Missing values in PivotTable

Ah, I see - let me see if plu‌ has any suggestions.

Patrik?

Employee
Employee

Re: Missing values in PivotTable

I am afraid that Jonathan jontydkpi‌ is right. The calculation will never be done since these combinations of Dim1 and Year don't exist in the data. So, no, I do not see a way to do this.

In QlikView there is the feature "Populate missing cells" that addresses this problem, but the corresponding functionality has not (yet) been exposed in Qlik Sense.

HIC

plu
Contributor III

Re: Missing values in PivotTable

I've added it to our improvement system so we can look at exposing a similar functionality.