topic Re: Compare between min, max and specific value in a line in App Development

Compare between min, max and specific value in a line

mfarsln — Wed, 27 Nov 2019 08:16:09 GMT

Hi,

I have a table like below:

product	source	value
a	source_1	10
a	source_2	30
a	specific_source	25
b	source_1	8
b	source_2	40
b	specific_source	40

What i want to do is comparing min, max and specific_source's values in some visuals for all products. Which visual should i use in order to show products' values in one line? I don't want to use bar chart which shows three bars for each product.

Thanks in advance.

Re: Compare between min, max and specific value in a line

Anil_Babu_Samineni — Wed, 27 Nov 2019 10:18:40 GMT

What is the outcome you are expecting by providing the same set?

Re: Compare between min, max and specific value in a line

mfarsln — Wed, 27 Nov 2019 10:56:59 GMT

I want to analyze what is the minimum, maximum and specific_source's value for all products. I can achieve that in simple straight table but i want to visualize it. I tried stacked bar chart with 3 measures (min value, max value ,specific_source value), but it doesn't show each stack value, it only shows the total for 3 measure. So it doesn't help either.

Re: Compare between min, max and specific value in a line

tresB — Wed, 27 Nov 2019 11:23:07 GMT

Try with qlik sense latest version (2019 Jun +), you can enable 'segment labels' in stacked bar chart.

Re: Compare between min, max and specific value in a line

mfarsln — Wed, 27 Nov 2019 21:41:37 GMT

Hi @tresB,

Thanks for your answer. Is it possible to change measure sorting?

What i want to do is that if db value (red) lower than max value (green) then it should be placed between white and green bars. If it is even lower than min value (white) then first bar would be the db (red).

Actually what i am trying to achieve is to get power bi's ribbon chart in qlik sense. Like below;

I'm adding sample data. Thanks.

Re: Compare between min, max and specific value in a line

tresB — Thu, 28 Nov 2019 07:13:36 GMT

Yes power bi ribbon chart is very helpful in such scenarios, and I don't know a similar qlik sense chart yet. However, you could search for extensions in qlik branch for a similar chart.

Re: Compare between min, max and specific value in a line

Anil_Babu_Samineni — Thu, 28 Nov 2019 08:47:14 GMT

1) Three Gauge Charts

2) Create Waterfall Chart

3) Use extensions..

Re: Compare between min, max and specific value in a line

mfarsln — Thu, 28 Nov 2019 09:10:41 GMT

Since there is more than 15 dimension values, can't use gauge or waterfall charts. And i couldn't find any extension for my needs as well.

Re: Compare between min, max and specific value in a line

Anil_Babu_Samineni — Thu, 28 Nov 2019 09:52:44 GMT

I would suggest you to use Inline data like

Island:

Load * Inline [

Metrics

Min

Max

];

Then, Create Bar chart

Dimension - Metrics

Expression - Pick(Match(Metrics, 'Min', 'Max'), Min(Value), Max(Value)…)

Re: Compare between min, max and specific value in a line

mfarsln — Thu, 28 Nov 2019 13:19:32 GMT

Hi Anil,

If i didn't have a product dimension your advice would work. But i already have a product dimension which i have to compare for all product's db values whether its between min and max values or not. And visualize it with any chart. I think there is no solution for this scenario in Qlik Sense.