Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
marcoalmeida
Creator II
Creator II

Extension Master Item Manager

Hi guys.

I'm using the Master Item Manager extension and have some problems.

I have variables and functions in my metric description, for example:

Sum of sales M-0

I modified the extension to concatenate the complete expression, being as follows:

description = "='" + row.cells[1].qText + "' & chr(10) & 'Expression: " + row.cells[3].qText + "'";
The value of row.cells[3].qText is: row.cells[3].qText is:

Sum({<[Transaction.Date.Period] = {"$(=Date(AddMonths(MonthStart(Max([TTransaction.Date.Period])), -0 ), 'YYYY-MM'))"}>}[Value])
But when I run the "Create Measure" extension, it does not interpret as functions and variables, keeping a string literal. The Qlik you will interpret when entering the metric and clicking save.

Is there any form of correction?

The output of the above case would be:

Sum of sales M-0
Expression: Sum({<[Transaction.Date.Period] = {"2019-04"}>}[Value])
Thanks!

Grupo Telegram Qlik Brasil: https://t.me/joinchat/AeRmnUmcxQ02L00g3x-HtQ
0 Replies