topic Re: Dynamic Lable names and expression issue in QlikView

Dynamic Lable names and expression issue

Anonymous — Sun, 05 Jul 2015 13:50:00 GMT

i have a project name='Yldnzav Eenqllaoa- Mjmeamro X'

if i select above project, in chart it should show savings for that project

savings 2015,savings 2016,savings 2017(After contract Term years expression)

how to name the lables dynamically?

how to calculate expressions for savings 2015,savings 2016,savings 2017

formulae for savings:(savings/3)

sample output:

year savings 2015 savings 2016 savings 2017

2015 $16,667 $0 $0

2016 $0 $16,667 $0

2017 $0 $0 $16,667

please find the attached sample application

Anonymous — Sun, 05 Jul 2015 13:58:41 GMT

It depends on your data model, could share a picture of it ?

Anonymous — Sun, 05 Jul 2015 14:42:56 GMT

hi Bill thanks for your time

here is the data model

New Year is the year field .

settu_periasamy — Sun, 05 Jul 2015 16:57:43 GMT

Hi,

you can try the below expressions.

instead of if condition, you can use the set expression

Savings 2015:

=(sum({<NewYear={'2015'}>}[Budget/Forecast])-sum({<NewYear={'2015'}>}[Managed Spend]))/3

Savings 2016:

=(sum({<NewYear={'2016'}>}[Budget/Forecast])-sum({<NewYear={'2016'}>}[Managed Spend]))/3

Savings 2017:

=(sum({<NewYear={'2017'}>}[Budget/Forecast])-sum({<NewYear={'2017'}>}[Managed Spend]))/3