Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Re: color by expression - QlikSense

I read all this long thread. Powerless, I chose for a google search with recent results, and I found the right thread.

Color scheme in qliksense for bar chart

That works well for me. If you believe that is the correct answer to this thread, please mark this reply as the solution, and we can help newcomers from reading all this thread.

Highlighted
Creator II
Creator II

Re: color by expression - QlikSense

Hi Philipp,

In Qlik Sense new release provide this type of functionality to give a specific color to the specific measure.

Please see my answer in below link for more detail.

https://community.qlik.com/message/1267037?et=watches.email.thread#1267037

Hope this will help.

Highlighted
Creator II
Creator II

Re: color by expression - QlikSense

Hi Philipp,

In the New version of the Qlik Sense ( i.e 3.2 SR1), it is possible to give a specific color to the multiple expressions (Measures).

I've given a different color in example attached by you in this blog and below is the resulting image.

Chart.PNG

To give a specific color to measure follow below steps:

1. Make Expression as Master Item (Measures).

2. In Master Item (Measures) Choose Specific Color for that expression.

3.Apply that Master Item Measure directly into Chart Measures.

Below are the Images for the Master Item Setting.

Master Item.PNG

Master Item Detail.PNG

Now use this Master Measure Item in Your Measure.

Highlighted
Contributor II
Contributor II

Re: color by expression - QlikSense

Hey steve this solution worked for me, thank you so much. I have one more functionality to be implemented on top of this. On selection of any month (i have Date instead of month dimension) I have to display data from 2  previous months along with selected month. For Example on the selection of July month, it should show data of May ,June and July.

I have to show data of all dates of this three month on selection of anydate from July. How can we do that?

I tried this

if(  ValueList('Dim1', 'Dim2', 'Dim3', 'Dim4')='Dim1', SUM({<Date = {"$(='>=' & Date(AddMonths(BusinessDate, -2)) & '<=' & Date(BusinessDate))"},Year={2011}>}Sales),

if(  ValueList('Dim1', 'Dim2', 'Dim3', 'Dim4')='Dim2', SUM({<Date = {"$(='>=' & Date(AddMonths(BusinessDate, -2)) & '<=' & Date(BusinessDate))"},Year={2012}>}Sales),

if(  ValueList('Dim1', 'Dim2', 'Dim3', 'Dim4')='Dim3', SUM({<Date = {"$(='>=' & Date(AddMonths(BusinessDate, -2)) & '<=' & Date(BusinessDate))"},Year={2013}>}Sales),

if(  ValueList('Dim1', 'Dim2', 'Dim3', 'Dim4')='Dim4', SUM({<Date = {"$(='>=' & Date(AddMonths(BusinessDate, -2)) & '<=' & Date(BusinessDate))"},Year={2014}>}Sales)

))))

PS: currently on selecting any date data is coming for one date only

Highlighted
Creator
Creator

Re: color by expression - QlikSense

Hi,

You should look at Set Analysis to achieve this. Using the date dimensions generated by the data preparation of the Data Manager you would have something similar to SUM({$<MonthsAgo={0,1,2}>} Measure1)

Please note that this thread is very old now and recent editions of Qlik Sense allow you to colour each measure separately by defining it in the master library.

Creating a master measure from a field ‒ Qlik Sense

Highlighted
Contributor
Contributor

Re: color by expression - QlikSense

Hi Philipp,


we have a direct option in sense. add both expressions to master measures there you can select the specific color for each measure.