Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rdlccn70
New Contributor II

Using variables in expression

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


8 Replies
MVP
MVP

Re: Using variables in expression

Try like

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

afernandezblade
New Contributor

Re: Using variables in expression

Hi,

Try:

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

sasiparupudi1
Honored Contributor III

Re: Using variables in expression

The variable must be wrapped in $()

Monat_Personal={'$(vPriorMonthPersonal)'}

rdlccn70
New Contributor II

Re: Using variables in expression

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

   

Numerictwo digits
101
202
303
404
505
606
707
808
909
1010
11

11

1212

rdlccn70
New Contributor II

Re: Using variables in expression

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

MVP
MVP

Re: Using variables in expression

Use

num(FIELD, '00')

rdlccn70
New Contributor II

Re: Using variables in expression

perfect, thank you.

oknotsen
Honored Contributor III

Re: Using variables in expression

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 .

May you live in interesting times!
Community Browser