Vizlib Home Try Vizlib
Welcome
Login
Submit a ticket
  1. Help Center
  2. Vizlib Community
  3. Feature Requests
  4. Pivot Table Coloring by Dimensionality
Planned

Pivot Table Coloring by Dimensionality

R
Randell Abbott
started a topic over 1 year ago

In the Qlik Sense pivot tables, we are able to color according to dimensionality {ex. If(Dimensionality()=1,'Blue'...)} which is the way my customers prefer to see pivot tables. Unfortunately, I have been unable to achieve this coloring effect using the "Background Color" option and the "Dynamic Styling" option in my Vizlib Pivot Table. Is there a particular syntax used in the Vizlib Pivot Tables? If this feature is not available, could it be added? See graphic below for example of desired coloring effect. Thanks!


image




  • Luke Tolchard
    said over 1 year ago
    Hi Randell,

    Thank you for raising this feature request with us at Vizlib.

    This feature will only work in pivot table objects that don't include the custom hypercube. This is already a known limitation of how this feature will behave.

    At the moment, the roadmap is already determined but I will go ahead and create an internal ticket for us to keep track of.
    - I will see if this can be included in the next roadmap planning session, or, be achieved earlier. I will keep you informed.

    Please note your unique ticket reference (#34944) and URL https://community.vizlib.com/helpdesk/tickets/34944

    Kind regards,
    Luke T
    Vizlib | Product Manager
  • Luke Tolchard
    said 24 days ago
    Hi Randell,

    How are you doing? I have finally gotten around to testing this and I am pleased to inform this already works. The problem that you may have had was that using 'blue' isn't calculated by Qlik and therefore you are returned nothing. The result is that your pivot table is then presented with the Global color set in Appearance.

    using this expression for both measure and dimensions, If(Dimensionality()=1,blue(), if(Dimensionality()=2,red(), yellow())), I was able to achieve the following image


    as a result of this function already existing in the pivot table, I am going to be closing this request as using such functions works fine. the image below show what the measure column looks like when the calculation is not calculuated correctly, either by the use of 'Blue' or an invalid color 'pink()'.


    Please note your unique ticket reference (#34944) and URL https://community.vizlib.com/helpdesk/tickets/34944

    Kind regards,
    Luke T
    Vizlib | Product Manager
Login to post a comment
Topics in this forum
View all

Didn't find what you were looking for?

Start a new topic