Master dimension - Can we use set analysis?

[shwetapsarda]

@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

[satishkurra]

Using color by expression, can you use silent legends.

I'm assuming this is not QlikSense

[shwetapsarda]

Thank you,  but this is Qlik Sense.

Can we have silent legend in sense?

[satishkurra]

Ok. In that case, the only way use to use themes.

C:\Users\yourusername\AppData\Local\Programs\Qlik\Sense\Client\themes\old

[shwetapsarda]

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.