topic Re: How to extract field name(s) from an Expression? in QlikView

How to extract field name(s) from an Expression?

Thu, 28 Jul 2016 18:51:11 GMT

Hi there,

I was wondering if there is a way of extracting fields used within expressions for instance Sales from Sum({<Name={'Alex'}>}Sales)?

I need a solution that can be applied on more complex expressions.

Many thanks,

Laleh

Re: How to extract field name(s) from an Expression?

sunny_talwar — Thu, 28 Jul 2016 19:29:29 GMT

extract it? extract the field name where? Not sure I understand, can you elaborate?

Re: How to extract field name(s) from an Expression?

Thu, 28 Jul 2016 19:57:25 GMT

Hi Sunny,

So, I am creating a table of all the expressions and the fields used in those expressions of my application.Something like this:

Now,I need to have a column that shows the fields used within each expression. Hope that make sense!

Re: How to extract field name(s) from an Expression?

sunny_talwar — Thu, 28 Jul 2016 20:21:47 GMT

It sort of does. I have no idea how to do this, but I hope someone else do (I will get to learn something new as well ) May be swuehl‌ or rwunderlich‌

Best,

Sunny

Re: How to extract field name(s) from an Expression?

Nicole-Smith — Thu, 28 Jul 2016 20:28:42 GMT

Are you aware that a tool that does exactly this already exists?

The Document Analyzer (Tools | Qlikview Cookbook) created by rwunderlich‌ will take care of all of this for you.

Re: How to extract field name(s) from an Expression?

Thu, 28 Jul 2016 20:52:29 GMT

Hi Nicole,

Thanks for your reply. Yes I am, just want to create a simpler solution for my application as it requires less complex functionality. And,I would learn something new if I could work it out.

Thanks again

Re: How to extract field name(s) from an Expression?

rwunderlich — Thu, 28 Jul 2016 23:53:56 GMT

You can look at the code in Doc Analyzer to see how I do it. Note that I don't actually parse the fields out of the expressions, but rather look for strings that match existing field names. Not too sophisticated, but it works.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: How to extract field name(s) from an Expression?

Sun, 31 Jul 2016 08:04:47 GMT

Hi rwunderlich‌,

Thanks for the info, I am looking into the Doc Analyzer script. Will get back to you if I need to understand how you did it. Great job I should say

Re: How to extract field name(s) from an Expression?

MarcoWedel — Sun, 31 Jul 2016 18:56:41 GMT

‌maybe the Governance Dashboard can help you as well to get an overview of your expressions.

regards

Marco