Qliksense Sales table

[ayush]

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

[msKarthikeyan]

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