8 Replies Latest reply: Jun 14, 2016 2:04 AM by Asma Riyaz

# Showing a mesure as relative % in Qlik Sense

Hi All,

I am new to Qlik Sense. I wish to show a measure as relative %. In Qlikview, this can be achieved by checking the check box of relative for the particular measure. Can anyone help me in achieving the same functionality in Qlik Sense.

Thanks,

Asma

• ###### Re: Showing a mesure as relative % in Qlik Sense

Hi,

It  can be done under properties.

Thanks.

• ###### Re: Showing a mesure as relative % in Qlik Sense

The above step mentioned converts the number to percentage,

e.g. if the value is 18,757, the after formatting it as 12.34%,  it returns 1875705.70% which is not the relative %.

The relative % should be (18,757/Total)  * 100 where total is the sum of all rows.

• ###### Re: Showing a mesure as relative % in Qlik Sense

What is the expression you are using right now?

• ###### Re: Showing a mesure as relative % in Qlik Sense

My expression is sum(Sales). I have created a table as shown below:

MeasuresTotalAB
Sales250100150
Sales %100%40%60%

I have created Sales Measure.

I want to create the Sales % measure.

In Qlikview, Sales % can be achieved by using the in built Relative option available as shown below:

Is there anything similar available in Qlik Sense?

Thanks,

Asma

• ###### Re: Showing a mesure as relative % in Qlik Sense

I don't think relative is available, but you can do as Rohan pointed out.

Sum(Sales)/Sum(TOTAL Sales)

• ###### Re: Showing a mesure as relative % in Qlik Sense

Thanks Sunny!!

• ###### Re: Showing a mesure as relative % in Qlik Sense

Hi Asma,

Something like this:

Make use of the Total function

Sum([Measure])/Sum(Total [Measure])

Make sure that you keep the number formatting simple and as shown in the image.

Regards,

Rohan

• ###### Re: Showing a mesure as relative % in Qlik Sense

Thanks Rohan for the detailed explanation!!