topic Re: Trend line for specific KPI's in QlikView

Trend line for specific KPI's

Anonymous — Mon, 26 Mar 2018 07:51:53 GMT

Hello Everyone,

my requirement is to show trend line(Line chart) for KPI 2015,2016,2017 when i select 2017 & when i select Year 2018 then it will be trend for KPI 2016,2017,2018.

I am not getting how to write expression, Please help me to find solution.

Thanks.

Re: Trend line for specific KPI's

adityaakshaya — Mon, 26 Mar 2018 08:35:37 GMT

Hi Prachi,

Attached application can help you to get your desired output. In this scenario, you need use calculated dimension and within expression, you have to use {1} so that you can get the values irrespective of selection

Regards,

Akshaya

Re: Trend line for specific KPI's

Anonymous — Mon, 26 Mar 2018 08:49:19 GMT

sorry but i can't share file.

Re: Trend line for specific KPI's

adityaakshaya — Mon, 26 Mar 2018 08:53:29 GMT

Hey Prachi,

I am tried to replicate it in test file and shared that with you .You can refer the scenario which you asked for.

Regards,

Akshaya

Re: Trend line for specific KPI's

stabben23 — Mon, 26 Mar 2018 09:04:15 GMT

Hi prachi,

is Your KPI listbox an dataisland, ex inline table that is not Connected to the datamodel?

Re: Trend line for specific KPI's

Anonymous — Mon, 26 Mar 2018 09:25:17 GMT

Please share screen shot. i am not able to open.

Re: Trend line for specific KPI's

adityaakshaya — Mon, 26 Mar 2018 09:35:32 GMT

Hi Prachi,

I use inline data load

LOAD * INLINE [

Year, Value

2015, 2

2015, 1

2015, 2

2015, 1

2016, 2

2016, 4

2016, 3

2016, 2

2016, 1

2016, 2

2017, 1

2017, 2

2017, 1

2018, 1

2018, 2

2018, 1

2018, 2

2018, 1

2018, 2

];

In Dimension, I use calculated dimension -

=If(Year>Year(AddYears(MakeDate(GetFieldSelections(Year),1,1),-3)) and Year<=GetFieldSelections(Year),Year)

Expression

sum({1}Value)

Re: Trend line for specific KPI's

Anonymous — Mon, 26 Mar 2018 09:57:10 GMT

You haven't used KPI in calculated dimension