Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

getting column information in expression of document

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

11 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Anonymous
Not applicable
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

Anonymous
Not applicable
Author

Hi Rob,

It is already running in production.

Regards,

Kumar

dionverbeke
Luminary Alumni
Luminary Alumni

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

Anonymous
Not applicable
Author

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

dionverbeke
Luminary Alumni
Luminary Alumni

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.

or

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

Kr,

Dion

Anonymous
Not applicable
Author

Thanks Dion.

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

Regards,

Kumar

Anonymous
Not applicable
Author

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