Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
Highlighted
shwetapsarda
New Contributor II

Master dimension - Can we use set analysis?

@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

4 Replies
satishkurra
Valued Contributor II

Re: Master dimension - Can we use set analysis?

Using color by expression, can you use silent legends.

I'm assuming this is not QlikSense

shwetapsarda
New Contributor II

Re: Master dimension - Can we use set analysis?

Thank you,  but this is Qlik Sense.

Can we have silent legend in sense?

satishkurra
Valued Contributor II

Re: Master dimension - Can we use set analysis?

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

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

shwetapsarda
New Contributor II

Re: Master dimension - Can we use set analysis?

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.