Showing a mesure as relative % in Qlik Sense

[riyazasma1009]

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

[arasantorule]

Hi,

It  can be done under properties.

Thanks.

[riyazasma1009]

Thanks for your reply!

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.

[sunny_talwar]

What is the expression you are using right now?

[riyazasma1009]

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

Measures	Total	A	B
Sales	250	100	150
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

[#6 · Accepted solution]

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

[sunny_talwar]

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

Sum(Sales)/Sum(TOTAL Sales)

[riyazasma1009]

Thanks Rohan for the detailed explanation!!

[riyazasma1009]

Thanks Sunny!!