Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Relationship between tables and charts

Is there a good document that you can recommend that will help me with defining relationships between Tables & Pie Charts?

I am working with expressions and formulas that work great in a straight tables. When identical expression is as part of the pie chart, formulas do not return desired values, or any values at all.

Please help!

8 Replies
shree909
Valued Contributor II

Re: Relationship between tables and charts

HI

i think u need to go through the reference manual/

in that they have clearly explained like how many dimesions and expressions are to be used for

particulat charts and table....

Thanks

Not applicable

Re: Relationship between tables and charts

Is this the manual that you are talking about?

Not applicable

Re: Relationship between tables and charts

I went through the manual and did not find anything about setting relationships. Please help

danielrozental
Honored Contributor II

Re: Relationship between tables and charts

Threre is not such a thing as relationships between tables and charts, if you're not getting the expected result then there is probably a problem with the expression you're using or the way you've model the data.

If you post a sample of your qvw we might be able to help you getting it right.

srikanthsri1
Valued Contributor

Re: Relationship between tables and charts

try to work on your data model for the given app

hit Ctrl+T you can see your data model arrganed

Not applicable

Re: Relationship between tables and charts

The problem is that i am working with 2 tables.  One of the fields only resides in table 2.

In the straight table i used 'IF' statement to hard code values from table 1. When i tried using the same formula in the part chat, hard-coded values are not appearing as part of the data.

What am i doing wrong?

danielrozental
Honored Contributor II

Re: Relationship between tables and charts

Post a sample of your qvw so we can look into it.

Not applicable

Re: Relationship between tables and charts

Something like this.

Community Browser