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: 
kolov007
Contributor III
Contributor III

found % for each field in the column from the the particular field in column

I want to find the share of each budget items by cost. As in the example below

Screenshot_1.png

I'm trying to use Set Analysis, but I get the following

Screenshot_2.png

Help me please.

1 Solution

Accepted Solutions
sunny_talwar

Try this:

sum(totalsum)/sum(TOTAL {<[budget items] = {'cost price'}>} totalsum)


Capture.PNG

View solution in original post

4 Replies
oknotsen
Master III
Master III

Try this:

sum([budget items]) / sum(TOTAL [budget items])

May you live in interesting times!
sunny_talwar

Try this:

sum(totalsum)/sum(TOTAL {<[budget items] = {'cost price'}>} totalsum)


Capture.PNG

oknotsen
Master III
Master III

Yeah, I think Sunny is a bit closer to the solution than my initial suggestion.

May you live in interesting times!
Kushal_Chawda

Create the variable on front end

vCost =sum({<[budget items] = {'cost price'}>} totalsum)

Now write the expression

=sum(totalsum)/$(vCost)