Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Try
=sum($(vRotate_month1)_Revenue)
No that didn't work.
I got red underline on "_Revenue" part
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.
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.