Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

Try this:

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


Capture.PNG

View solution in original post

4 Replies
Highlighted
Master III
Master III

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

Try this:

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

May you live in interesting times!
Highlighted

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

Try this:

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


Capture.PNG

View solution in original post

Master III
Master III

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

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

May you live in interesting times!
Highlighted

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

Create the variable on front end

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

Now write the expression

=sum(totalsum)/$(vCost)