topic Re: Formula in expression in a PivotTable in QlikView

Formula in expression in a PivotTable

Tue, 20 Dec 2011 10:18:48 GMT

How to convert text such as '2 +2' or '(20 * 5) / 100' on an outcome. But I need to do this from an expression in a PivotTable.

Re: Formula in expression in a PivotTable

Sokkorn — Tue, 20 Dec 2011 10:30:32 GMT

Hi,

Try this =Replace(Field,CHR(39),'')

See the sample attached file also.

HTH and let me know.

Regards,

Sokkorn Cheav

Re: Formula in expression in a PivotTable

Tue, 20 Dec 2011 10:35:22 GMT

But in your example does not return the results

Re: Formula in expression in a PivotTable

Sokkorn — Tue, 20 Dec 2011 11:10:05 GMT

Hi,

Try this once again

[tmp]:
LOAD * INLINE [
ID,TEST
1,''2+2''
2,''5*2''];
[Data]:
LOAD
    ID                                                        AS [ID2],
    Evaluate(Replace(TEST,CHR(39),''))        AS [TEST2]
Resident [tmp];
DROP TABLE [tmp];

Regards,

Sokkorn Cheav

Formula in expression in a PivotTable

Tue, 20 Dec 2011 11:25:27 GMT

In my case, I can do the calculation in the scrip as the operand I have to be calculated based on filters set by the user on another table.