topic Re: Using variables in expression in QlikView

Using variables in expression

rdlccn70 — Thu, 10 Mar 2016 13:46:05 GMT

Hi all,

i have following Expression:

(Sum({<DATA_PERSONAL_EBENE ={'IST'},Jahr_Personal ={'2015'},Monat_Personal=(vPriorMonthPersonal)>[DATA_PERSONAL_WERT]))

Everything is ok, but i have a problem with the variables vPriorMonthPersonal. How can i use this in the Expression?

Thank you.

Regards,

Erdal

swuehl — Thu, 10 Mar 2016 14:11:01 GMT

Try like

Sum({<DATA_PERSONAL_EBENE ={'IST'},Jahr_Personal ={'2015'},Monat_Personal={'$(vPriorMonthPersonal)'} >} [DATA_PERSONAL_WERT])

afernandezblade — Thu, 10 Mar 2016 14:11:59 GMT

Hi,

Try:

(Sum({<DATA_PERSONAL_EBENE ={'IST'},Jahr_Personal ={'2015'},Monat_Personal={"$(vPriorMonthPersonal)"}>[DATA_PERSONAL_WERT]))

sasiparupudi1 — Thu, 10 Mar 2016 14:15:47 GMT

The variable must be wrapped in $()

Monat_Personal={'$(vPriorMonthPersonal)'}

rdlccn70 — Thu, 10 Mar 2016 15:47:05 GMT

Hi, thank you ver much. it works with Monat_Personal={'$(vPriorMonthPersonal)'}, bu i have another question.

How can Change a number in two Digits like this

My vPriorMonthPersonal is numeric and i Need in two Digits. Is there a function like Format??

Regards

Erdal

rdlccn70 — Thu, 10 Mar 2016 15:48:14 GMT

Hi it works with '....', not with "...". Thank you.

swuehl — Thu, 10 Mar 2016 19:07:41 GMT

Use

num(FIELD, '00')

rdlccn70 — Fri, 11 Mar 2016 13:50:47 GMT

perfect, thank you.

oknotsen — Fri, 11 Mar 2016 15:15:47 GMT

If your question is now answered, please flag the Correct Answer.

If not, please make clear what part of your question you still need help with .