getting column information in expression of document

[Anonymous]

Hi Experts,

As part of enhancement in Dashboard one of report needs to be modify according to the requirement.

Now we are analyzing existing columns and one of the column not able find from which dimension or fact table is coming.

I have done analysis in QVD loader script and in Qlikview model(ctrl-T after we can see list of columns from each table) and inline tables

and in show fields from all table which is under dimension tab for chart properties. Even variable list also and this is not calculated column.

So any other where we can find out column.

Please help me on this.

Regards,

Kumar

[Anonymous]

Hi Sreekanth.

Thanks. Here already this column is available in expression, but I ma not able not see neither in QVD loader nor in script editor.

Is there any chance can we get it from .ini file(which is available in include section)

Regards,

Kumar

[rwunderlich]

It looks like to me that the field does not exist at all in your data model.  Someone removed it from the model but did not update the expression.  So just remove it from the expression, or replace it with something else if you need the filtering that it is supposed to provided.

This is more common than you expect. The expression:

sum({<foo={abc}>} Sales)

will return a result even though the field "foo" does not exist.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com