Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Set Analysis - Using variables for comparison

Hello,

I'm trying to use variables on a count aggregation but it's not working

COUNT({< vIntervalo = {'>500'}>}CLIENTE)

when vIntervalo is SUM({<MOTIVO ={ 'NOR'  }>} VALOR_BX )

My goal is to show the CLIENTE (customers) counting that vIntervalo (sales) is bigger than 500.

I've been triend many syntaxes and also created a second variable with 500 content.

Appreciate any help.

Tks

1 Solution

Accepted Solutions

Re: Set Analysis - Using variables for comparison

Try: Count({<CLIENT={"=$(vIntervalo)>500"}>}CLIENTE)


talk is cheap, supply exceeds demand
5 Replies
reddys310
Honored Contributor II

Re: Set Analysis - Using variables for comparison

Hi Filipe,

Try this:

count( {$ < vIntervalo={">$(value)"} >}[Vehicle ID])

Thanks,

Sangram

Re: Set Analysis - Using variables for comparison

Try: Count({<CLIENT={"=$(vIntervalo)>500"}>}CLIENTE)


talk is cheap, supply exceeds demand
Not applicable

Re: Set Analysis - Using variables for comparison

Hello Sangram,

thanks for reply but it didn't work. Actually it is adding the whole value like without filtring {">$(500)"}

count( {$ < vIntervalo={">$(5000)"} >}CLIENTE)

maybe I could try to don't use variable but don't know the correctly sintaxe.

Tks anyway

Not applicable

Re: Set Analysis - Using variables for comparison

Hello Gysbert

thanks for reply but it also didn't works. Actually it is adding the whole value like without filtring {"=$(vIntervalo)>5000"}

Count({<CLIENT={"=$(vIntervalo)>5000"}>}CLIENTE)

maybe I could try to don't use variable but don't know the correctly sintaxe.

Tks anyway

Not applicable

Re: Set Analysis - Using variables for comparison

Gysbert


It works! Just fix the variable (CLIENT to CLIENTE) and done!


Thank you!!


By the way great community! Fast replies.. awesome =]

Community Browser