Set analysis calculation

[ksk278074]

HI Experts,

I have 2 filed called product and sales like below

product,sales

a,10

b,20

c,30

d,40

 now for each record i want calculations like   10/sum(sale)

20/total sales

30/total sales

how to write the expression? 

[MohammedMustaq]

Try these

=sales/Sum(Total sales)

Thanks

Mustaq

[ksk278074]

no i am not getting correct value.

[MohammedMustaq]

Take Dimension as

product

and Measure = sales/Sum(Total sales) 

in pivot ,straight  table or in any chart. it will show you by product wise.

if these won't work Share your sample app.

[ksk278074]

Thanks for sharp reply.
i am getting output as 1

can you please share the sample qliksense app

[ksk278074]

got the solutions