topic Re: qlikview in QlikView

qlikview

prasad — Sat, 16 Nov 2024 21:32:49 GMT

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

Re: qlikview

jonathandienst — Thu, 24 Jan 2019 05:16:22 GMT

How are the rows selected for the percentage?

Re: qlikview

MindaugasBacius — Thu, 24 Jan 2019 06:02:35 GMT

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?

Re: qlikview

prasad — Thu, 24 Jan 2019 06:05:06 GMT

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

Re: qlikview

qliksus — Fri, 25 Jan 2019 02:27:55 GMT

May be this

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

Re: qlikview

prasad — Fri, 25 Jan 2019 02:34:07 GMT

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),
))