Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.

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

- Qlik Community
- :
- Forums
- :
- Analytics
- :
- New to Qlik Analytics
- :
- 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

782 Views

1 Solution

Accepted Solutions

Anonymous

Not applicable

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) ) )

663 Views

4 Replies

Anonymous

Not applicable

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) ) )

664 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) **

663 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.

663 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

663 Views

Community Browser