Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
@Hi, !
I am using line chart with two dimensions and one measure for rolling 13 months analysis. My chart works properly for displaying values but the color disappears when I choose the AsOfDate.Month filter.
Details about chart,
First dimension is :
if([AsOfDate.MonthIndex]<= $(=Max("AsOfDate.MonthIndex"))and [AsOfDate.MonthIndex]>= $(=Max("AsOfDate.MonthIndex")-12),[AsOfDate.Month])
Second dimension is: Master dimension Risk Rating where I have assigned colors for each Risk Rating.
Measure: sum({<[AsOfDate.Month]=> } Exposure )
This gives me
Last 13 months trending with proper values and colors. As soon as I select AsOfDate.Month filter, chart gives proper values but the color disappears.
(This works properly if I use color by expression feature. But problem with this is No Legend display. So I want to use master dimension)
So,I want to define master dimension as Risk rating with {<[AsOfDate.Month]=> } set analysis. I also want to use value colors feature for assigning colors to Risk rating.
How can do this?
Thanks in advance,
Shweta
Using color by expression, can you use silent legends.
I'm assuming this is not QlikSense
Thank you, but this is Qlik Sense.
Can we have silent legend in sense?
Ok. In that case, the only way use to use themes.
C:\Users\yourusername\AppData\Local\Programs\Qlik\Sense\Client\themes\old
Thank you. I know very little about themes. I think theme can customize colors and fonts. I want legend to display with assigned colors which can be achieved using master dimension . Can this be done using custom theme?
I appreciate if I can get little more details about this.