Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

riyazasma1009
New Contributor III

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

1 Solution

Accepted Solutions
Not applicable

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.

dem.png

Regards,

Rohan

8 Replies
arasantorule
Contributor III

Re: Showing a mesure as relative % in Qlik Sense

Hi,

It  can be done under properties.

Number Formating.PNG

Thanks.

riyazasma1009
New Contributor III

Re: Showing a mesure as relative % in Qlik Sense

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.

Re: Showing a mesure as relative % in Qlik Sense

What is the expression you are using right now?

riyazasma1009
New Contributor III

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

Not applicable

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.

dem.png

Regards,

Rohan

Re: Showing a mesure as relative % in Qlik Sense

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

Sum(Sales)/Sum(TOTAL Sales)

riyazasma1009
New Contributor III

Re: Showing a mesure as relative % in Qlik Sense

Thanks Rohan for the detailed explanation!!

riyazasma1009
New Contributor III

Re: Showing a mesure as relative % in Qlik Sense

Thanks Sunny!!

Community Browser