# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Valued Contributor II

## Help with Set Analysis

Hi !

Im trying to count the OID_METER when CONSUMO_TOTAL > 1,5* CONSUMO_ESPERADO, but i can relate two dimensions.

How can i do this?

Count({<CONSUMO_TOTAL = {">1.5* CONSUMO_ESPERADO"}>} OID_METER) ???

1 Solution

Accepted Solutions
MVP

## Re: Help with Set Analysis

May be this

Count({<OID_METER = {"=CONSUMO_TOTAL > (1.5* CONSUMO_ESPERADO)"}>} OID_METER)

4 Replies
MVP

## Re: Help with Set Analysis

May be this

Count({<OID_METER = {"=CONSUMO_TOTAL > (1.5* CONSUMO_ESPERADO)"}>} OID_METER)

Valued Contributor II

## Re: Help with Set Analysis

Hi Sunny ! How Long.

It works perfectly

May i ask you another think related?

If i want in that selection, only CONSUMO_TOTAL > 5. How can i do that, because will be 2 selection for the same Count(Meter)?

Maybe

Count({<OID_METER = {"=CONSUMO_TOTAL > (1.5* CONSUMO_ESPERADO)"}, {"=CONSUMO_TOTAL > 2"}>} OID_METER) ?

MVP

## Re: Help with Set Analysis

May be this

Count({<OID_METER = {"=CONSUMO_TOTAL > (1.5* CONSUMO_ESPERADO) and CONSUMO_TOTAL > 2"}>} OID_METER)

Valued Contributor II

Thank You !