Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New 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
Honored Contributor 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

Highlighted
Honored Contributor 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)