Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sgg_gaikwad
New Contributor II

How to perform row level Calculation in Pivot table...?

I was trying to perform row level calculation on these dimension  like   china , india, Japan

=IF(CountryName='China',$(vchina), CountryName)

My Variable Contain ---- sum([Unit Cost])/(sum(Units))---

3 Replies
amit_saini
Honored Contributor III

Re: How to perform row level Calculation in Pivot table...?

Swapnil,

Do you mean something like that below: (Suppose I'm doing w.r.t row number 25 in my pivot table)

=IF(not isnull(BalancePosition) and rowno <> 25 and Type = vSpalte3,BalancePosition)

Thanks,
AS

maleksafa
Valued Contributor

Re: How to perform row level Calculation in Pivot table...?

not clear, can you elaborate more your problem?

sgg_gaikwad
New Contributor II

Re: How to perform row level Calculation in Pivot table...?

Capture.PNG.png  

i want to show these ACtual , Budget , Last year Calculation in Percentage for the particular Account Code..

Community Browser