Solved: Re: Fields giving 0 result - Page 3 - Qlik Community

Report Inappropriate Content · ‎2012-02-03

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

Report Inappropriate Content · ‎2012-02-07

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.

Report Inappropriate Content · ‎2012-02-07

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?

Report Inappropriate Content · ‎2012-02-07

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 · ‎2012-02-07

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.

Report Inappropriate Content · ‎2012-02-07

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 · ‎2012-02-07

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

Report Inappropriate Content · ‎2012-02-07

It didn't work..

swuehl · ‎2012-02-07

Seems to work at my place....

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

Report Inappropriate Content · ‎2012-02-07

Did you drop field company from all tables?

Report Inappropriate Content · ‎2012-02-07

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!