Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ksk278074
Contributor III
Contributor III

Set analysis calculation

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? 

Labels (1)
5 Replies
MohammedMustaq
Partner - Creator
Partner - Creator

Try these

 

=sales/Sum(Total sales)

 

Thanks

Mustaq

ksk278074
Contributor III
Contributor III
Author

no i am not getting correct value.
MohammedMustaq
Partner - Creator
Partner - Creator

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
Contributor III
Contributor III
Author

Thanks for sharp reply.
i am getting output as 1

can you please share the sample qliksense app

ksk278074
Contributor III
Contributor III
Author

got the solutions