topic Re: Expression in QlikView

Expression

adiarnon — Mon, 13 Oct 2014 04:50:40 GMT

hi,

I want to count the number of projects that

Sum(budget)>0

and

Sum(budget)<100

and

age>20

tnx adi

Re: Expression

PrashantSangle — Mon, 13 Oct 2014 05:07:39 GMT

Hi,

Try like this

count(if(Sum(budget)>0 and Sum(budget)<100 and age>20,Projects)

Regards

Re: Expression

tresB — Mon, 13 Oct 2014 05:16:09 GMT

Front-end? May be like:

=Count(If(Aggr(Sum(budget), Dimension)>0 and

Aggr(Sum(budget), Dimension)<100 and

age>20,Dimension))

Re: Expression

jagan — Mon, 13 Oct 2014 05:18:10 GMT

Hi Adi,

Try like this

Sum(Aggr(if(Sum(budget)>0 and Sum(budget)<100 and age>20, 1),Projects))

Hope this helps you.

Regards,

Jagan.

Re: Expression

adiarnon — Mon, 13 Oct 2014 05:22:16 GMT

hi tnx!!!

can i do that with a set analysis?

Re: Expression

jagan — Mon, 13 Oct 2014 05:35:29 GMT

Hi,

Try like this

=Count({<Projects={" =Sum(budget)>0 and Sum(budget)<100"}, Age={'>20'}>} DISTINCT Projects)

Regards,

Jagan.

Re: Expression

adiarnon — Mon, 13 Oct 2014 06:05:02 GMT

hi,

tnx!

i will try this.

i didnt knew that i can use 'and' in set analysis...

Re: Expression

adiarnon — Mon, 13 Oct 2014 08:13:26 GMT

its not working =(

any other soluitions?

Re: Expression

tresB — Mon, 13 Oct 2014 08:19:51 GMT

Could you create a sample qvw and share here?

Re: Expression

jonathandienst — Mon, 13 Oct 2014 08:28:54 GMT

The set analysis method will not work in a table or chart where the sum(budget) or age may differ from row to row, as the set expression is calculated once for the whole table, not once per row.

HTH

Jonathan