# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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:

 IDGeneral Type IDSystem System IDLicense License IDCompany Company NoCompany 1111 A 1 A 1 A 1 A 1 1212 A 1 A 2 B 1 A 2 2121 B 2 B 1 A 2 B 1 2222 B 2 B 2 B 2 B 2 2223 C 2 B 2 B 2 B 3

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

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)