Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hello,
That works fine.
BR
Serhan
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.
I have got missing data not Null data but thank you for input.
Thanks Jonathan,
I hope this will be an option in version 2.0.4 or later
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
Sorry I can not share the app but as you see on the picture value for two categories for 2011 is missing
How to add white background to this field and replace the '-' ?
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
I've added it to our improvement system so we can look at exposing a similar functionality.