This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Now i want to show if (Margin%)<90% ,Blue color till 90,after 90 to 100 other color ,similary 4 Colors in Single bar .
How to achieve this.any help would be greatly appreciated.
Plz find the attached report screen.
maybe color as expression :
if(yourMeasure<0.9, blue(), green())
Thanks for your time,i used same but if value for Q1 is 150, its >90 so till end bar showing single color.
i want till 90 one color ,90 to 100 one color .....
I don't sure to understand. Can You try this?
Excuse me I have click reply in the wrong place.
if ( Margin <= 90,BLUE(),
if ( Margin > 90 and Margin <= 100,Red(),
You can add more if conditions within it
if you want it exactly the colors of the picture you posted:
if (Margin <= 90, Blue(),
if(Margin > 90 and Margin <=95, lightGray(),
if (Margin >95 and Margin < 100, Yellow(), Green ()
Thanks for your time.
i want this in Qlik sense
Create a Synthetic Dimension for <90, 90-100,>100
Modify your measure to show these Values
Use Pick(wildmatch(Valuelist('<90', '90-100','>100'),'<90', '90-100','>100'),
Try this way.. It might help