topic Re: Resolving Expression : Variable & text string in QlikView

Resolving Expression : Variable & text string

Fri, 12 Apr 2013 19:13:17 GMT

Hello,

I have declared variable as part of my script. It assigns value based upon month.

So, if Current_month = 'April' , variable will be "vMonth1_Revenue'. (Field has revenue for month of April). It loads fine.

Now, I want to do summation on "vmonth1_Revenue". The problem is column show up as "April_Revenue". I am going to refresh the report every month so I want to refer variable instead of actual column name.

I tried following variety of expression, all of them either gave me "Missing ( - ) " or " Zero ( 0 )" or nothing as output.

=sum(TEXT('$(=vRotate_month1)'&'_Revenue'))

=sum($(=vRotate_month1) &'_Revenue'))

=sum('$(vRotate_month1)' & 'Revenue_' )

One suggestion was to create another variable: vTEST= vRotate_month1&'_Revenue' and do =sum(vTEST).

It works, but I have 20 variable to sum upon. I don't want to create 20 temproary variables. I am sure there is easy way.

Help me out.

Re: Resolving Expression : Variable & text string

Fri, 12 Apr 2013 20:09:54 GMT

Try

=sum($(vRotate_month1)_Revenue)

Re: Resolving Expression : Variable & text string

Fri, 12 Apr 2013 20:40:12 GMT

No that didn't work.

I got red underline on "_Revenue" part

Re: Resolving Expression : Variable & text string

Fri, 12 Apr 2013 22:08:16 GMT

You have to ignore the red underline error indicator in the expression editor. If vTEST= vRotate_month1&'_Revenue' and =sum(vTEST) works then =sum($(vRotate_month1)_Revenue) will work also.

Re: Resolving Expression : Variable & text string

jozsefpeitli — Tue, 16 May 2017 13:35:20 GMT

Dear All,

Unfortunately it is not working for me...

I am using qlik sense.

I try to achieve something like this:

I can set this: "vMeaseure = FieldName"

I try to use this as a measure:

=$(vMeasure)_min

To achieve this:
=FieldName_min

How should I use it properly?

So I have a lot of Field in my table. And I have another table with the same fieldname + "_min".

Thank you for your help.