topic Re: VARIABLE IN TABLE in QlikView

VARIABLE IN TABLE

adiarnon — Thu, 13 Apr 2017 08:59:17 GMT

HI,

I HAVE THIS TABLE

IN THE GRADE COLUMN I NEET TO CALCULATE THE GRADE

FOR EACH METRIC I HAVE A VARIABLE WITH THE FORMULA FOR HIS GRADE

SO NOW I HAVE IN THE GRADE COLUMN THE VARIABLE

BUT HOW CAN I GET THE RESULT OF THE VARIABLE?

THE EXPRESSION OF THE GRADE EXPRESSION IN THE TABLE -

='v_'&Metric_ID

Anil_Babu_Samineni — Thu, 13 Apr 2017 09:27:43 GMT

What are you trying to achieve. And you gave expression is correct as you are showing.

adiarnon — Tue, 18 Apr 2017 04:54:59 GMT

i want that the column in the table will calculate the expression in the variable

Anil_Babu_Samineni — Tue, 18 Apr 2017 05:02:33 GMT

You can use like below

Load *, 'v_'&Metric_ID as Grade;

And use he same Grade field in tabular