Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Basically, Table 1 is sales view by country, I want to see % of Total Sales which is nothing but country wise sales/total sales.
Col “% GT Sales” is quick calculation feature in power BI by which you can reach similar result as in “% of total sales”.
need to See if quick calculations are available in qlik sense.
Table2 is filtered for top 3 countries by sales, see if this you can reach in qlik sense.
Now,
if you see % GT sales col doesn’t give the desired result that’s where % of table sales calculation is important.
How to achieve this is Qliksense
Hi Ayush,
you can try:
Sum(Sales)/Sum(total Sales)
total is a qualifier which doesn't change with dimension in the chart but respects the filter conditions.
-Karthik