How to use realtive value restrictions?

[DWolsie]

Hello everyone,

I hope I'm using the correct terminology since my Qlik Sense is not in German.

I'm trying to the relative value restrictions on my bar chart, such that it only shows 20% of the sum of the measure. In other words, I want to show as many bars on my bar chart, that the sum of them totals 20% of the sum of the total measure.

Thanks in advance!

Updating Media

[sbaro_bd]

Hi @DWolsie ,

You image isn't visible. Can you provide us again an image? Thanks.

Regards.

[DWolsie]

Hi @sbaro_bd, my apologies! This is the image I was trying to attach:

[sbaro_bd]

@DWolsie ,

If i translate the condition : "show me all bars on the chart where the relative part/weight of each of them in total is strictly inferior at 20%". The 20% limitation is defined for each bar on your chart.

As you have a lot of bar on your chart, you probably need to reduce this relative limitation.

Regards.

[DWolsie]

Hi @sbaro_bd ,

Unfortunately, I don't quite understand what you mean.

Is it possible for me to show only 20% of the sum? Either with or without using relative values

Kind Regards

[sbaro_bd]

Hi @DWolsie ,

Find an attached a file with the steps to get the expected result. I make an example with a barchart.

Regards.

[DWolsie]

Hi @sbaro_bd ,

Thank you so much for the help! Unfortunately I do not have the ability to view/upload qvf files 😞