Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

Re: Expression for colour by measure

hi

if you find the solution then close the thread .

Partner
Partner

Re: Expression for colour by measure

As a Measure (format it as %)

(sum({<Year={"$(=max(Year))"}>}YourMeasure)

-

sum({<Year={"$(=max(Year)-1)"}>}YourMeasure))

/

sum({<Year={"$(=max(Year)-1)"}>}YourMeasure)


As a label:

='Growth from '&(max(Year)-1)&' to '&(max(Year))


With that when you select 2017 for example; u'll have the growth from 2016 to 2017 and so on.


ronman10
Contributor

Re: Expression for colour by measure

Omar,

Will the above formula work only for 2 years or more? I have data from 2015-2018.

Regards,

Rony

Partner
Partner

Re: Expression for colour by measure

What do u mean?

In ur KPI object, what do you want to have?

Exactly?

Highlighted
ronman10
Contributor

Re: Expression for colour by measure

I want the kpi to show growth rate for 2016 over 2015, 2017 over 2016, 2018 over 2017 as and when the selections are applied.

Partner
Partner

Re: Expression for colour by measure

this is 3 separate measures; u can't have all 3 of them in the KPI object.

Instead;

use a bar/line/combined chart; as a dimension: Year

as a measure;the measure I've already given you.

try it and see what happens

ronman10
Contributor

Re: Expression for colour by measure

OKay. Thanks Omar.

ronman10
Contributor

Re: Expression for colour by measure

Hi Omar,

Which one should I be taking here?

Rony

Partner
Partner

Re: Expression for colour by measure

u're talking of this?

(sum({<Year={"$(=max(Year))"}>}YourMeasure)

-

sum({<Year={"$(=max(Year)-1)"}>}YourMeasure))

/

sum({<Year={"$(=max(Year)-1)"}>}YourMeasure)


As a label:

='Growth from '&(max(Year)-1)&' to '&(max(Year))