Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eduardo_dimperi
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
MVP

Re: Help with Set Analysis

May be this

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

4 Replies
MVP
MVP

Re: Help with Set Analysis

May be this

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

eduardo_dimperi
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
MVP

Re: Help with Set Analysis

May be this

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

eduardo_dimperi
Valued Contributor II

Re: Help with Set Analysis

Thank You !