Discussion board where members can get started with Qlik Sense.
I want to create a Percentages based on the range of Amount by Year and Company. Please find the details below. I tried a couple of approaches but I am not able to achieve the expected result.
Result Table: This is giving me the percentages of all the years.
if(aggr(sum(Amount),Year,Company)<50,'Less then 50',
if(aggr(sum(Amount),Year,Company)>=100 and aggr(sum(Amount),Year,Company)<=200 ,'100-200',
if(aggr(sum(Amount),Year,Company)>500,'Greate than 500',
if(aggr(sum(Amount),Year,Company)>50 and aggr(sum(Amount),Year,Company)<700 ,'50-700',
But the Expected Result I want is to show the 100% split per each year.
Also, I will convert this table to 100% Stacked bar color by PLAN SIZE. So that I can see how much percentage of plan size for each year.
Thanks in Advance,
Go to Solution.
So, With all the respect and information provided by the gentlemen in this thread. Both the expressions will give the right output.
sum(Amount) / aggr(sum(total <Year> Amount),Year,Company)
Since my report consuming more than 10 Million records of data. I have to test which is the better one in terms of
I was able to find the solution. All I need to change the percentage expression. Which is.
However, I have to convert this result set into a 100% stacked bar.
Better yet, use this
I tried this expression but I am getting the wrong Percentage split.
Seems like something to do with the calculated dimension.... Not sure why it creates an issue
add the calculated dimension and you will see what he means
Yes. If you add the calculated dimension the results will vary.
Ah I see !
change ur measure to :
After converting the Pivot table to a 100% stacked bar chart. I got it what I want. . There might be a better solution than this. But as of now, this solution helped me in fixing my issue.