topic Re: getting column information in expression of document in QlikView

getting column information in expression of document

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: getting column information in expression of document

rwunderlich — Tue, 16 Jan 2018 19:20:17 GMT

Can you post the expression or dimension you are questioning?

Sometimes it can be difficult to find a column when using the table viewer. An easier solution is to create listboxes for

$Field and $Table. If you don't see those fields, Right-click the sheet, "Select Fields" and check the "Show System Fields" checkbox.

-Rob

Re: getting column information in expression of document

Anonymous — Wed, 17 Jan 2018 01:45:44 GMT

Hi Rob,

Thanks for your reply.

I tried as you said but I couldn't see that particular column. Can you see a below screen shot what I am looking for.

Thanks

Kumar

Re: getting column information in expression of document

rwunderlich — Wed, 17 Jan 2018 04:04:05 GMT

Does the syntax checker say "Invalid Column" for [Cloud Billing]? It's possible this column does not exist in your data model.

-Rob

Re: getting column information in expression of document

Anonymous — Wed, 17 Jan 2018 04:40:10 GMT

Hi Rob,

It is already running in production.

Regards,

Kumar

Re: getting column information in expression of document

dionverbeke — Wed, 17 Jan 2018 07:05:50 GMT

Is it not related to the syntax checker bug, where the columns before -= set analysis are not shown correctly?

Re: getting column information in expression of document

Anonymous — Wed, 17 Jan 2018 09:20:03 GMT

Hi dion,

Thanks for your response.

In a place of [Cloud Billing] I have given my some junk characters and it is taking as expression valid.

I don't how it is validating. These should come from tables.

Can you correct me will it take the columns which are not part of tables?

Regards,

Kumar

Re: getting column information in expression of document

dionverbeke — Wed, 17 Jan 2018 09:29:13 GMT

All columns are part of a table by Qlik definition.

As Rob said: are you sure it is in your data model?

Can you send a screenshot of the Table Viewer (Ctrl + T) . If done correctly it will show in which table your field is.

Can you attach your document and I will find it for you.

Kr,

Dion

Re: getting column information in expression of document

Anonymous — Wed, 17 Jan 2018 11:43:26 GMT

Thanks Dion.

It is not available in data model. Since it is a huge file I could not attach.

Regards,

Kumar

Re: getting column information in expression of document

Anonymous — Wed, 17 Jan 2018 12:06:31 GMT

Hi Kumar,

Check it that filed exists in data model(Ctrl+T) or not?

If Not:

If that fields is not exists, try to get into data model.

If Yes:

If field is available in data model still you are getting the error , check it inside the set analysis expression.

Thanks & Regards,

Venkata Sreekanth

Re: getting column information in expression of document

Anonymous — Wed, 17 Jan 2018 12:13:35 GMT

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

Re: getting column information in expression of document

rwunderlich — Wed, 17 Jan 2018 17:21:50 GMT

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