Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Search instead for
Did you mean:
Contributor III

## qlikview

Hi, I need to get one extra column as GetPercentage. This one I need to get by dividing row4/row7 etc. As there are other rows which also I need, this is an example. How to achieve this in Qlikview load script or expression. Thanks in Advance.

Attached is the pic image

Labels (3)

• ### QlikView

1 Solution

Accepted Solutions
Contributor III
Author
There are few columns, what I need eg: RowNo Column : row 4(Total4) /ColumnG(Total\$)ie row 7 :

(384144.15/634425.14)*100 I need to get 60.55 next to the row4 Total Column. Pls see the image for reference. Tks! in Advance

5 Replies
Partner - Champion III

How are the rows selected for the percentage?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Partner - Specialist III
I guess that in in Front end you should you Pivot or Straight table.
In dimension add Fiscalyear.
In expressions:
1. Label Accommodation, expression = Sum({<Description = {'ACCOMMODATION'}>} Total\$)
2. Label Sales, expression = Sum({<Description = {'SALES-CASH'}>} Total\$)
3. Label Revenue, expression = Sum({<Description = {'TOTAL REVENUE'}>} Total\$)
4. Label Accommodation %, expression = Accommodation/Sales
5. Label Sales %, expression = Sales/Revenue

Is it what you wish to achieve?
Contributor III
Author
There are few columns, what I need eg: RowNo Column : row 4(Total4) /ColumnG(Total\$)ie row 7 :

(384144.15/634425.14)*100 I need to get 60.55 next to the row4 Total Column. Pls see the image for reference. Tks! in Advance

Specialist II

May be this

Sum(totals)/below(total Sum(totals),3)

Contributor III
Author
I was able to resolve using set analysis. Thanks! all for the advise
=100*Sum(Count)/
If(Match(Class, 'SALES-CASH', 'DOCTOR CHARGE'), Sum(TOTAL {<Class = {'TOTAL REVENUE'}>} Count),
If(Class = 'SURGICALS & CONSUM', Sum(TOTAL {<Class = {'TOTAL COST OF SALES'}>}Count)
Services'}>}Count),
))
Community Browser