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: 
GrantBooth
Creator
Creator

Pivot Table Error with Unicode Objects - Colour missing

Having the strangest problem with pivot tables and unicode objects.

I have a Pivot Table with six dimensions and five columns. The 5th column is a conditional statement

if($(v.MTD(Actual)) < $(v.MTD(Budget)), chr(10060), chr(9989))

What is strange is that most of the time the unicode objects appear black and white, it is only when a user hovers over an item, or the pivot table is collapsed fully, do we see any colour. I also have several other Pivot Tables which all have the same problem. This is a new issue which did not exist when the table was built.

GrantBooth_0-1637725335876.png

 

I've checked text colour expression for the measure and it's blank, so that's not the problem, and I've tried creating new ones from scratch and they have the same problem. There are no issues with colour anywhere else in the app.

 

1 Solution

Accepted Solutions
GrantBooth
Creator
Creator
Author

The formula used wasn't returning NULL anywhere, this was tested by using the same logic in text colour expression using

if($(v.MTD(Actual)) < $(v.MTD(Budget)), red(), green())

I was able to solve the problem by using this expression in conditional text colour in column with the emoji.

View solution in original post

3 Replies
marcus_sommer

Your comparing of $(v.MTD(Actual)) < $(v.MTD(Budget)) could be invalid on the TOTAL levels and returning then NULL. This could happens if not all calculation-parts of your variables are aggregations, for example by querying there something like: if(AdType = ... On the granular level this could be resolved but on the TOTAL there are then multiple values available and causing the NULL which forced the whole expression to NULL.

In such a case you will need to wrap the condition with an aggr() like:

if(sum(aggr($(v.MTD(Actual)) < $(v.MTD(Budget)), AdType)), this, that)

- Marcus

GrantBooth
Creator
Creator
Author

What are you referring to with AdType?

GrantBooth
Creator
Creator
Author

The formula used wasn't returning NULL anywhere, this was tested by using the same logic in text colour expression using

if($(v.MTD(Actual)) < $(v.MTD(Budget)), red(), green())

I was able to solve the problem by using this expression in conditional text colour in column with the emoji.