Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have one requirement in QlikSense. But I don't know how to do it as I am new to qliksense.
Add logic to color code the text on the reports based on the dimension Transaction Type. (there is an article on the Qlik Developers site that shows how dimension values can be set up as color coded – this way no logic needs to be added to all of the charts).Transaction Type has below Values,.Can anyone give example on this and explain.?
- Direct = default
- Tracings/Rebates = brown
- Adjustments (all others) = dark blue
Thanks,
Rupali Ethape.
i dont think you can change all chart colors by changing one place we need to edit each chart
Hi Rupali,
In table/pivot under expression properties go to text color expression and you can write
=if(Transaction='Direct',RGB(164,227,0),If(Transaction='Rebates',RGB(154,227,0),RGB(0,90,160)))
PS:RGB codes can be your need.
Hi,
In Qliksense, you can color dimension values using master items as shown in below screenshot.Once you create the Dimension in master items, click Edit then you can see "Value Colors" option.
Hi,
How to apply to text or chart?
Thanks,
Rupali Ethape