Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
Something like this:
Make use of the Total function
Make sure that you keep the number formatting simple and as shown in the image.
It can be done under properties.
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:
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?
I don't think relative is available, but you can do as rohandsouza pointed out.
Thanks Rohan for the detailed explanation!!