Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]
please can you elaborate more. I did not get what exactly are you trying to say?
Hi Pankaj,
Your Amount spreadsheet data and link should GLAccount wise then you can use the [Current Assets]/ [Current Liabilities]
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
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.
Check the link has happened correctly or not. I mean Data of Primary and reference key is same format and same or not.
maybe you have to aggregate, please try with
=sum(Current assets/ current liabilities)
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?