Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

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

Announcements

Qlik Cloud Maintenance is scheduled between March 27-30. **Visit Qlik Cloud Status page for more details.**

- Qlik Community
- :
- Forums
- :
- Analytics
- :
- New to Qlik Sense
- :
- Barchart - show measure of measure as (100%) bar -...

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

varmekontrol

Creator

2017-09-20
06:24 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Barchart - show measure of measure as (100%) bar -And determin Color.

Hi

This answer has been asked before in this forum, and have been solved.

But I am having a hard time understanding/implementing the solution in my scenario.

I have two measures I would like to split in a stacked bar chart, so the highest measure is 100% of the bar chart, and the scond measure is the XX% of that 100%

Setup is as following:

Dimension: =propertyNumber

Measure 1 sum(numberEG) (this is the 100%)

Measure 2: Sum(numberEG30Day)

This is the result...

So how do I configure my chart so -> *sum(*numberEG*)* will be 100% - and *Sum(numberEG30Day) *would be the % of the 100%..

And just to challenge people in here.....

I would like if *sum(*numberEG*) *is color* *#0A2864 and *Sum(numberEG30Day) *is color #E63F0C

401 Views

1 Solution

Accepted Solutions

bill_markham

Champion III

2017-09-20
06:53 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

If I am understanding you correctly maybe something like this

Measure 1 :

- 1 - ( sum(numberEG) / ( sum(numberEG) + Sum(numberEG30Day) ) )

Measure 2 :

- 1 - ( Sum(numberEG30Day) / ( sum(numberEG) + Sum(numberEG30Day) ) )

282 Views

4 Replies

bill_markham

Champion III

2017-09-20
06:53 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

If I am understanding you correctly maybe something like this

Measure 1 :

- 1 - ( sum(numberEG) / ( sum(numberEG) + Sum(numberEG30Day) ) )

Measure 2 :

- 1 - ( Sum(numberEG30Day) / ( sum(numberEG) + Sum(numberEG30Day) ) )

283 Views

varmekontrol

Creator

2017-09-20
07:27 AM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi

That looked like that did the job...

I do not know why it suddently changed to 100% from the formular you used.

But nevertherless it worked.

Do you also know how to.

**I would like if sum(numberEG) is color #0A2864 and Sum(numberEG30Day) **

282 Views

pradosh_thakur

Master II

2017-09-20
07:43 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

set the back ground color of the expression by clicking expression-> back ground color then set the color u want to for the expression .. in your case you need to set the color for measure 1 and measure 2.

Learning never stops.

282 Views

varmekontrol

Creator

2017-09-20
12:24 PM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Pretty new at this, so correct me if I am wrong...

I converter my hex to arbg color.

ColorMix1((1+Sign(2*(sum(numberEG) - sum(numberLMC)-RangeMin (top(total sum(numberEG) - sum(numberLMC),1,NoOfRows(total))))/(RangeMax (top(total sum(numberEG) - sum(numberLMC),1,NoOfRows(total)))-RangeMin (top(total sum(numberEG) - sum(numberLMC),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(sum(numberEG) - sum(numberLMC)-RangeMin (top(total sum(numberEG) - sum(numberLMC),1,NoOfRows(total))))/(RangeMax (top(total sum(numberEG) - sum(numberLMC),1,NoOfRows(total)))-RangeMin (top(total sum(numberEG) - sum(numberLMC),1,NoOfRows(total))))-1))))/2,ARGB(240, 140, 109, 1),argb(34,34,34,1))

And this was this was the result..

Would it be sossible so that the

282 Views