Solved: Chosing some of the cases - Qlik Community

Report Inappropriate Content · ‎2012-07-02

=if(m3_tot_engasjem>=tot_engasjem,sum(m3_tot_engasjem/tot_engasjem)

I want to give a percentage increase for those that have increased their sum, omitting those that have decreased their amount.

Data is like:

jonathandienst · ‎2012-07-02

Hi

Try

Avg($(vTot)) Or Avg($(=$(vTot)))

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Report Inappropriate Content · ‎2012-07-02

What is your question? Does your expression not work?

Maybe you could try if(sum(m3_tot_engasjem)>=sum(tot_engasjem),sum(m3_tot_engasjem)/sum(tot_engasjem))

Anonymous · ‎2012-07-02

Hi kiteulfen99,

I guess your expression is correct. All you need to remove is the sum

=if(m3_tot_engasjem>=tot_engasjem,(m3_tot_engasjem/tot_engasjem))

Beacuse may be you dont wish to take the sum aggregrate of it.

This may work for you or you can even use frankcrezee expression and convert the format with number and Show in %

Report Inappropriate Content · ‎2012-07-02

I am still having problems with this:

SET vTot = if (m3_tot_engasjem>=tot_engasjem,(m3_tot_engasjem)/(tot_engasjem)-1);

When I am using this variable later on with an avg(vTot) it renders just blanks over the dimensions.

Kiteulfen 99

jonathandienst · ‎2012-07-02

Hi

Try

Avg($(vTot)) Or Avg($(=$(vTot)))

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein