topic Re: Help avoid a lot of work in QlikView

Help avoid a lot of work

Fri, 30 Jan 2015 17:34:52 GMT

Hello All,

I creating a report to help us know if our eCommerce site is recording data and need a way to evaluate each field. I can to this with text boxes, but would like to avoid it. Does any one know how to achieve this in the script. I could do an huge if statement, but would also like to avoid that.

Here are some pictures that could help give context:

Re: Help avoid a lot of work

sujeetsingh — Fri, 30 Jan 2015 17:55:27 GMT

You can use the $Fields available in every script.

You do not need to do it in script it is easily possible in UI.

Search for Robs posts in community. He has developed a document analyse which works a lot on the $Fields,$Tables you can reap some concept from there.

Re: Help avoid a lot of work

marcus_sommer — Sat, 31 Jan 2015 09:15:36 GMT

See here: http://community.qlik.com/message/603055#603055

- Marcus