Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fabianaiglesias
Contributor

Data comparison

Hi

I need to calculate the value of an expression exclusively for a group of data and compare them with one value; in my case, the solvency ratio for one company and compare these ratio with different sector´s companies

I´m calculating the solvency ratio where:

Solvency ratio = $(vEquity)/$(vAssets) (as a master element)

vAssets = sum({<IDAccount={'10'}>}Money)

vEquity = sum({<IDAccount={'30'}>}Money)

The groups of companies are like these:

   

IDGeneralTypeIDSystemSystemIDLicenseLicenseIDCompanyCompanyNoCompany
1111A1A1A1A1
1212A1A2B1A2
2121B2B1A2B1
2222B2B2B2B2
2223C2B2B2B3

I need to compare the Solvency ratio of my company (IDGeneral = 1111) against the groups whose IG general starts with '12', '21' and '22' in a bar graph

1 Reply
Digvijay_Singh
Honored Contributor III

Re: Data comparison

You may create one synthetic Dimension in bar chart as - Valuelist('MyCompany','Startswith12','Startswith21','Startswith22')

and measure as -

Pick(Match(Valuelist('MyCompany','Startswith12','Startswith21','Startswith22'),'MyCompany','Startswith12','Startswith21','Startswith22'),

Expressionforyourcompany,Expressionfor12,Expressionfor21,Expressionfor22)


The expessions in above measure can calculate specific values for other groups like -

vAssets12 = sum({<IDGeneral={"12*"}>}Money)

vEquity12 = sum({<IDGeneral={"12*"}>}Money)

Community Browser