QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Valued Contributor II

How to modify my expression to make -0.155 change to -15,5% ?

Hi

Below expression work fine :-

=NUM(

count(distinct(if(inv>'800000' and  inv<'899999' and CYTD,inv)))

-

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)))

)

/

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)))

it display as -0.155 , May i know how to make it display -15.5% ?

I try below it does not work :-

=NUM(

count(distinct(if(inv>'800000' and  inv<'899999' and CYTD,inv)))

-

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)))

)

/

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)))

, '#.#%') &

Hope some one can advise me.

Paul

1 Solution

Accepted Solutions
MVP

Re: How to modify my expression to make -0.155 change to -15,5% ?

Try this:

=NUM(

(count(distinct(if(inv>'800000' and  inv<'899999' and CYTD,inv)))

-

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv))))

/

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv))), '##.0%')

5 Replies
MVP

Re: How to modify my expression to make -0.155 change to -15,5% ?

May be this:

=NUM(

count(distinct(if(inv>'800000' and  inv<'899999' and CYTD,inv)))

-

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)))

)

/

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)), '##.0%')

or

=NUM(

count(distinct(if(inv>'800000' and  inv<'899999' and CYTD,inv)))

-

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)))

)

/

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv)) * 100, '##.0') & '%'

Valued Contributor II

Re: How to modify my expression to make -0.155 change to -15,5% ?

Hi Sunny

I have try both your expression , it display null , it does not able to convert -0.3125 to %. ( I have reload to smaller file now the value have change from -0.155 tp -0.3125 )

Enclosed my QVW file.

Paul

MVP

Re: How to modify my expression to make -0.155 change to -15,5% ?

Try this:

=NUM(

(count(distinct(if(inv>'800000' and  inv<'899999' and CYTD,inv)))

-

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv))))

/

count(distinct(if(inv>'800000' and  inv<'899999' and LY_YTD_Flag,inv))), '##.0%')

Valued Contributor

Re: How to modify my expression to make -0.155 change to -15,5% ?

!Hi Paul,

Try it

Regards

Miguel del Valle

Valued Contributor II

Re: How to modify my expression to make -0.155 change to -15,5% ?

Hi All

Thank you both Sunny & Miguel help , now work fine.

Paul