Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Help avoid a lot of work

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:DonteTextbox formula.PNG

2 Replies
Honored Contributor III

Re: Help avoid a lot of work

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

Community Browser