Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
Highlighted
New Contributor II

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
Highlighted
Partner
Partner

Re: Set analysis calculation

Try these

 

=sales/Sum(Total sales)

 

Thanks

Mustaq

Highlighted
New Contributor II

Re: Set analysis calculation

no i am not getting correct value.
Highlighted
Partner
Partner

Re: Set analysis calculation

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.

Highlighted
New Contributor II

Re: Set analysis calculation

Thanks for sharp reply.
i am getting output as 1

can you please share the sample qliksense app

Highlighted
New Contributor II

Re: Set analysis calculation

got the solutions