topic Re: percentage issue in QlikView

percentage issue

arulsettu — Wed, 21 May 2014 07:01:56 GMT

in my straight table i am showing percentage like this

i used this code to show symbols

if(Column(5) < 1,'▼'&

Column(5) > 1,'▲')

but the result is 0.

what is my mistake?

Re: percentage issue

its_anandrjs — Wed, 21 May 2014 07:05:44 GMT

Use image in place of the symbols like and change your expression like sample expression

if(Column(5) < 1,'qmem://<bundled>/BuiltIn/arrow_s_r.png','qmem://<bundled>/BuiltIn/arrow_n_g.png')

Note:-

1.And make the expression as Image from Expression properties >> Display option >> Representaiton >> select (Image)

2. And then Image formatting >> Keep Aspect

Re: percentage issue

its_anandrjs — Wed, 21 May 2014 07:13:28 GMT

You can also use this symbols but change your expression as image

if(Column(5) < 1, '▼','▲')

Note:-

1.And make the expression as Image from Expression properties >> Display option >> Representaiton >> select (Image)

2. And then Image formatting >> Keep Aspect

Re: percentage issue

Wed, 21 May 2014 07:15:33 GMT

change your if condition as below:

if(Column(5) < 1,'▼','▲')

Re: percentage issue

arulsettu — Wed, 21 May 2014 07:17:17 GMT

result is

Re: percentage issue

its_anandrjs — Wed, 21 May 2014 07:18:42 GMT

Try with this

if(Column(5) < 1, '▼','▲')

Re: percentage issue

arulsettu — Wed, 21 May 2014 07:20:49 GMT

below 6 i need show down arrow and above 6 need to show up arrow

Re: percentage issue

its_anandrjs — Wed, 21 May 2014 07:27:45 GMT

Ok problem here is the values are in % then change your expression like multiple expression by 100

if(Column(5) * 100 < 1, '▼','▲')

if(Column(5) * 100 < 1, 'qmem://<bundled>/BuiltIn/arrow_s_r.png', 'qmem://<bundled>/BuiltIn/arrow_n_g.png')

Re: percentage issue

arulsettu — Wed, 21 May 2014 07:29:39 GMT

hi Anand

below 6% down arrow

above 6% up arrow

now it showing up arrow for all percentage

Re: percentage issue

arulsettu — Wed, 21 May 2014 07:32:18 GMT

for all down arrows showing now

for this if(Column(5) * 100 < 1, '▼','▲')

Re: percentage issue

its_anandrjs — Wed, 21 May 2014 07:37:50 GMT

Updated new query now check

Then try with

if( Column(5) * 100 < 6, 'qmem://<bundled>/BuiltIn/arrow_s_r.png', 'qmem://<bundled>/BuiltIn/arrow_n_g.png')

if( Column(5) * 100 < 6, '▼' , '▲')

Note:- Or may be you have to use vice versa for values

Re: Re: percentage issue

arulsettu — Wed, 21 May 2014 07:42:41 GMT

hi anand

here is the app

Re: percentage issue

Wed, 21 May 2014 07:55:19 GMT

Arul,

Look at the true values of column 5 you can see that your expression is producing all negative values which you are masking by using the relative option, I would recalculate your percentages to be true values and this will work.

Re: Re: percentage issue

arulsettu — Wed, 21 May 2014 07:58:17 GMT

Re: percentage issue

its_anandrjs — Wed, 21 May 2014 08:06:43 GMT

In your application some values are not calculated because no values or may be it is negatives otherwise formula is correct or you can use Coumn(5) check your expression it is column(1) otherwise all seems fine. Check same formula with vise versa with < or > with formula.

Regards