Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
It can be done under properties.
Thanks.
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.
What is the expression you are using right now?
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
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
I don't think relative is available, but you can do as rohandsouza pointed out.
Sum(Sales)/Sum(TOTAL Sales)
Thanks Rohan for the detailed explanation!!
Thanks Sunny!!