I need your help I have two field One is dimension(State) and measure(Sales) I want to set gradient color my chart bit not able to find any option for this can you please help me how to do this.
Note* I am working on Qlik sense cloud
What type of graphic are you implementing, Bars or Lines? Have you explore the colouring feature in Master Items? both Dimensions and Measures extending the colouring options!
Hope this helps,
After reading your answer I learned about master measure and more or less its working fine. but as I want not able to find how to set segment limit according to my output I have attached both the scenario.
2.What I want.
Can we make single color as gradient instead of applying different color using limit.
I am preparing my data to populate India, with its states!!! I will be able to get back to you in 24 hours, as I am preparing some data as well.
Thanks for the data it will help, I suspect that you are trying to apply shadows of red over the map, probably driven by a rate or proportion, if my guess is on target, perhaps you will find these replies helpful, the topic is about applying gradients of colours to a pivot table, but the procedure to do it, could also help your challenge.
I will be busy in the next 18 hours, so it will be difficult for me to look at your question, but I can't wait to give it a try, in the meantime, this Topic may give you more ideas, that solution implements and combine ColorMix1() and ARGB()
I think I cracked the Qlik's colour palette! the attached qvf illustrates it, but let me explain, I introduced a Total Case Palette # dimensions, e.g. TC_P1, TC_P2, TC_P3 ... and so on while trying to understand how the palette works; I referenced this HTML Colour Picker to pick up the colours to render, let's start with the procedure.
Now, some screenshots supporting this procedure, note, you will see the measure TC_P3 in some screenshot, I expect your to be Total Cases.
Accessing the Segment Colors Palette.
Explaining the Palette:
Selecting colors per bracket:
Applying colours to the map selecting colouring By Measure (Note the screenshot show the TC_P3 measure, you should user yours); with the Map rendering and its legend.
I hope this procedure help you to assign appropriated colour to the map!
Yes it's working fine but my question is that for every limit we need to assign specific HAX code here. is it not possible once I will select color for 100 % limit then color for rest of the limit distribute automatically.
Actually, it is possible but we have to enter two colours instead, the 0% and 100% colours, it works by
Interesting, we can achieve the same result with different approaches, each one affecting the legend; there is also an option by implementing the following expressing for colouring (with ColorMix1(); Rank() and Argb()):
=ColorMix1(Rank(TOTAL Sum([Total Cases]),4)/(NoOfRows(TOTAL)), argb(255, 255, 0, 0), argb(128,255, 230,255))
My answer is different from yours why it's happening.
ColorMix1(Rank(Total Sum([Covid-19 District wise data.Total Cases]),4)/NoOfRows(TOTAL),ARGB(255, 255, 0, 0), argb(128,255, 230,255))
and can you please elaborate this function.