calculating Ratios in Pivot table.

[#1]

Hello All,

I am working on 1 FI report using QV11 version.

Report Name: Ratio Analysis.

In this report, I have to calculate ratio of Current Assets/  Current Liabilities.

For this I have maintained an excel and linked GL accounts for assets and liabilities.

all these gl accounts from excel are linked to amt field from the database through gl_account.

But I am unable to write expression for division.Administrator

[bbi_mba_76]

Hi,

I don't understand so much, but you have to create a chart, add your dimensions and then as expression

=[Current Assets]/  [Current Liabilities]

[#3]

please can you elaborate more. I did not get what exactly are you trying to say?              

[#4]

Hi Pankaj,

   Your Amount spreadsheet data and link should GLAccount wise then you can use the [Current Assets]/  [Current Liabilities]

[jonathandienst]

Hi

This not be difficult to do, but it is very difficult to guide you without more information. At the very least, upload a sample of the spreadsheet containing the data. Better still, upload a sample Qlikview model containing the data relevant to your post.

HTH

Jonathan

[#6]

yes data and spreadsheet are linked GLAccount wise.

I tried to write the expression for Current assets/ current liabilities, but it is not working. it is giving 0.

[#7]

Check the link has happened correctly or not. I mean Data of Primary and reference key is same format and same or not.

[bbi_mba_76]

maybe you have to aggregate, please try with

=sum(Current assets/ current liabilities)

[#9]

Hi,

I have maintained 1 more column in excel with N or D

and wrote the expression as sum({ Divisor = {'N'} >} Amt)/ sum({< Divisor = {'D'} >} Amt)

and this is working fine.

But now I want 3 levels of division. eg.: a/b/c

How to do this?