topic Re: calculating Ratios in Pivot table. in QlikView

calculating Ratios in Pivot table.

Fri, 10 Jan 2014 06:59:07 GMT

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

Re: calculating Ratios in Pivot table.

bbi_mba_76 — Fri, 10 Jan 2014 07:21:40 GMT

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]

Re: calculating Ratios in Pivot table.

Fri, 10 Jan 2014 09:34:40 GMT

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

Re: calculating Ratios in Pivot table.

Fri, 10 Jan 2014 09:54:08 GMT

Hi Pankaj,

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

Re: calculating Ratios in Pivot table.

jonathandienst — Fri, 10 Jan 2014 10:01:15 GMT

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

Re: calculating Ratios in Pivot table.

Fri, 10 Jan 2014 10:43:32 GMT

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.

Re: calculating Ratios in Pivot table.

Fri, 10 Jan 2014 10:53:56 GMT

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

Re: calculating Ratios in Pivot table.

bbi_mba_76 — Fri, 10 Jan 2014 11:18:15 GMT

maybe you have to aggregate, please try with

=sum(Current assets/ current liabilities)

Re: calculating Ratios in Pivot table.

Mon, 13 Jan 2014 11:38:23 GMT

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?