Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
cchadda91
Contributor III
Contributor III

conditional color line chart in Qliksense

Since it is not possible to have dynamic legends for combo chart as there is no "Fx" in the measures.

As an alternative I have taken separate text objects showing the "Top Portfolios" i.e 3 separate text boxes for top 3 and bottom 3  for which I will assign same colors as used in combo chart measures(conditional colors)

How do I make my condition color expression in combo chart work here.

Message was edited by: chitral Chadda

Message was edited by: chitral Chadda

15 Replies
ishanbhatt
Creator II
Creator II

Hi Chitral,

Apologies for the delayed response. 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

Please find the attached app.

Hope this answer gratify your requirements.

cchadda91
Contributor III
Contributor III
Author

So great of you to revert back Ishan.

Thank you .

I doubled tried to download 3.2 SR version but i could get version 3.1 SR6 only.

As a result I cannot find the below color option in existing 3.1 version. Could you share the link ?

unnamed.jpg


Its that these legends/ Measure names have be dynamic so it could be that if supposedly now the top portfolio is "ABC" next time as data volume increases it could be that top portfolio (on the basis of profit) may be "XYZ" . But using this approach the name is  not dynamic it will display always "ABC" as we have hardcoded in the master name area of measures.

In that case what could be done as there is no "fx" capabilities (making it dynamic) in the labels/name for measures to make it dynamic(means they will also have to be dynamic).

An alternative to this is :

1. I would continue to use 6 separate text boxes which is dynamic i.e it will show"XYZ" if it is top portfolio .

2. will hide the legends for the chart in this case our text box would serve the purpose of legends-- ( we cant show chart legends as the  names have to be dynamic but we have hardcoded it in master items name.

3. Keeping the color as static both in text box and chart for the (top/ bottom 3 portfolios)

ishanbhatt
Creator II
Creator II

Hi Chitral,

I did not have Partner Credential to download latest Qlik Sense version.

In latest version still, Qlik Sense has no such functionality for dynamic label name Except only PIvote table. We can use a variable with the $ sign in Pivot label.

Hope this helpful to you.

cchadda91
Contributor III
Contributor III
Author

Ishan ,

Sorry off late I back in my mind I thought I had posted comment and was waiting for yours but just noticed I myself did not revert back.

So its that  like in your first comment you had attached an image where we could add color for in Master items measure .

The below is what you shared earlier.

Master Item Detail _Measures.PNG

And this is what i see cant find color option like above below description ( i m using version 3.1 SR 4)

Master Item Detail _Measures_cannot find color option.PNG

ishanbhatt
Creator II
Creator II

Hi Chitral,

Yes, I Can see that you are using Qlik Sense Desktop 3.1 SR1 version. But my response was explaining Qlik Sense Desktop 3.2 SR1 version. below is the screenshot of Qlik Sense version which I am using.

Qlik Sense version.PNG

Below is the link of the latest Qlik Sense Setup.

https://da3hntz84uekx.cloudfront.net/QlikSenseDesktop/3.2.4/204/_MSI/Qlik_Sense_Desktop_setup.exe

Ishan.

cchadda91
Contributor III
Contributor III
Author

Ishan,

Thanx..oh nice now its available.

Let me check will update

ishanbhatt
Creator II
Creator II

By the way, Qlik Sense release 3.2.4.

I've upgraded it but I am facing some authentication problem. So, better to continue with an older release until new release will stable.

cchadda91
Contributor III
Contributor III
Author

Do you have the link for the older release on which i could actually leverage this master item measure color functionality or should i wait for this version to get stable.

Get Outlook for iOS<https://aka.ms/o0ukef>

cchadda91
Contributor III
Contributor III
Author

Currently i will be using the link you shared

https://da3hntz84uekx.cloudfront.net/QlikSenseDesktop/3.2.4/204/_MSI/Qlik_Sense_Desktop_setup.exe

Get Outlook for iOS<https://aka.ms/o0ukef>