topic Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ? in App Development

Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Sun, 26 Jun 2016 00:39:13 GMT

Hi All

I copy the this KPI from QS example , i dont know how to make the % change to red color when % is +ve ? Now it display black color , i need to make it display Red color when -ve. Now alway black.

I have try use the below expression , i insert at color value :-

=if([Sales vs Target] <0% ,'#d01919','#545352')

But it does not work.

Paul

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Sun, 26 Jun 2016 00:45:21 GMT

My qvf

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

Mon, 27 Jun 2016 00:55:25 GMT

Hi Paul,

The app is showing invalid visualisation (the visualisation was not found on the server: qsSimpleKPI).

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

Anonymous — Mon, 27 Jun 2016 04:55:27 GMT

Hi Paul,

you can change ur expression to the below expression:

=if([Sales vs Target] <0 ,RGB(255,0,0),RGB(0,255,0))

Note:

Change the RGB values according to the colour u want

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Mon, 27 Jun 2016 05:34:18 GMT

‌Hi Karupreet

thank you for your reply , I will try this evening.

DOes it mean that QLIK VIEW script for Color expression is not same as KPI Sample ? Need to follow KPI Sample style of writing ?

PAul

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Mon, 27 Jun 2016 05:36:15 GMT

‌HI Nhu

KPI Simpel is qlik sense extension.

in order to remove the error , you need to install KPI SIMPLE EXTENSION to your QS DESKTOP .

NEed to to downlod from qlik branch .

thank you for your help

paul

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

Anonymous — Mon, 27 Jun 2016 06:54:47 GMT

Hi Paul,

What exactly is ur requirement ? you want to make the text colour change or the bar/ line colours?

If you want to the chnege the text colours then u need to write the same expression in

Right Cick -> Properties -> Font -> Colour -> Calculated Expression

and if you want to change the bar colour then

Right Cick -> Properties -> Expression -> Add your expression -> You will find a plus sign on the expression name, click on that -> colour -> paste the above expression

Regards

Karunpreet

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Mon, 27 Jun 2016 07:09:49 GMT

Hi Karunpreet

Base on your reply , I think you refer qlik view right ?

Paul

Sent from my iPhone

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

Anonymous — Mon, 27 Jun 2016 07:31:22 GMT

Yeah. But u can write the same expression in QlikSenseas well

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Mon, 27 Jun 2016 08:18:50 GMT

I am refer to KPI EXTENSION for qlik view

Sent from my iPhone

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

danansell42 — Mon, 27 Jun 2016 10:04:42 GMT

Hi Paul

It doesn't seem to be evaluating [Sales vs Target].

if you was to replace this with the full expression then the colors will change.

e.g.

if(if(

(

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000/Rate)

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/1000/Rate)

)

>1,1,

(

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000/Rate)

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/1000/Rate)

)

) >0 ,'#d01919','#545352')

Thanks

Dan

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Mon, 27 Jun 2016 12:17:03 GMT

Hi Karunpreel

I already try your expression in QS , but the color of the text never change.

Enclosed my QS QVF file

I have created 2 KPI box , one is -ve % another one is +Ve % , but both display black.

Paul

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Mon, 27 Jun 2016 12:50:12 GMT

Hi Daniel

I have try to place your expression into Box 1 and 2 . Both display same red color. can you take a look of my qvf ?

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

danansell42 — Mon, 27 Jun 2016 14:27:54 GMT

Hi Paul

For your test calculation you have added -1* 'calculation' to turn the number negative

Whereas in the colour expression you haven't added the same.

Therefore when it evaluates the expression the number is still positive and therefore red.

Thanks

Dan

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Mon, 27 Jun 2016 14:59:50 GMT

Hi Daniel

I have add *-1 to simulate.

if you look at below image you will notice that the 2 box , one is +ve another one is -ve , why the text color same color ?

Paul

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

danansell42 — Mon, 27 Jun 2016 15:07:54 GMT

As mentioned above, you haven't included the *-1 in the colour expression to finish of the simulation.

The colour expression evaluates separately from your main expression and is therefore still calculating a positive number.

I've just tested it and works perfectly for me.

Example for colour expression:

if(-1*if(

(

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000/Rate)

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/1000/Rate)

)

>1,1,

(

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000/Rate)

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/1000/Rate)

)

) >0 ,'#d01919','#545352')

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Mon, 27 Jun 2016 16:33:15 GMT

Hi Daniel

I think I understand now. But then it is possible to make use of macro ? So that when I make change of the actual expression , it will not affect the value Color expression ?

Paul

Sent from my iPhone

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

danansell42 — Mon, 27 Jun 2016 16:37:36 GMT

Hi Paul

Not really sure about macro's.

And it seems you can't use the master items as part of the color expression unfortunately.

Hopefully its been at least partially resolved and warrants a correct answer for now

Dan

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Mon, 27 Jun 2016 21:42:44 GMT

hi Daniel

thank you very much for your help.

PAul

Re: Simple KPI How to make % variance when +ve color change to Blue -ve RED ?

paulyeo11 — Thu, 30 Jun 2016 01:42:47 GMT

Hi Daniel

I have check with the simple KPI developer , how to make use of macro for his KPI , the reply as below :-

https://mail.google.com/mail/u/0/?tab=wm#inbox/15591447c2b0fbab

it is possible you can share with me what Mr Alex try to said ? As i cannot understand.

Paul