Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fields giving 0 result

Hi guys,

I run an SQl query to get the required fields.

now when I add all the fields and designs that I need of them is making a mess.

it is called division.

On my fields I have Division, Department, Names and revenue.

everything runing perfect with out having the division field selected.

once I select one of the divison options the revenue shows as 0.

also, when selected it is recognizing the right departments but keeping them white and turning the other departments which are not related to that division in gray color.

Any Idea on why the revenue turning into Zeros.

Thanks

29 Replies
Not applicable
Author

I found that if you display a table of relationship between division and department, all departments have a null division asigned also.

I believe that when you select a division, although the relation exists, maybe the amounts are asigned to the null division.

The model is the problem for sure.

Not applicable
Author

It could be..

all what I want to have now is a divisions table where I click on any of the divisions, its departments get selected..

Do you have any solution?

Like can we associate the departments with  divisions on a spreadsheet and make the requirement happen?

Not applicable
Author

What I mean by that, is creating a button when I click it the direct sales values that shows under department on a previous image will all be selected?!

BTW, Thanks for your help

swuehl
MVP
MVP

Not 100% sure, but I think your problem are different values in the COMPANY fields in table PNL and table BacklogSplit1. One seem to be 'ATL' and one is 40. Since COMPANY is also a key field, you want get a valid link between division and amount.

Not applicable
Author

They are different values in each table but I dont see that could make a problem..

Is there anyway to create a button or a selection that I lick on it and the department with direct sales will be selected?

swuehl
MVP
MVP

It is a problem because it is a key field (note the synthetic key). Try commenting out the COMPANY field in table BacklogSplit1.

Not applicable
Author

It didn't work..

swuehl
MVP
MVP

Seems to work at my place....

Just did a binary load of your data and dropped field COMPANY.

Not applicable
Author

Did you drop field company from all tables?

Not applicable
Author

Yessss!!

Thank you so ,uch!

I saved the field as different name and it worked out..

you are right the company field is making the error.

Thanks!