Something weird happens with my graph. HELP PLEASE

[Manuel174102]

Hello everyone.

I created a bar chart based on an excel, which I did not really link to any of the previous tables that I uploaded in the data manager.((The dashboard is almost finished)

I created the bar chart, it went great, it shows the information that I need to show, but the problem is.... when I filter anything in my dashboard, the information in the bar chart goes away and it only shows an empty diagram.

how could i solve this?

[justISO]

Hi, does your filters are from this same table you created bar chart from? Probably, you are filtering dimension from another table, and, as it is not connected with table for bar chart, it just cuts off data here.

[Manuel174102]

no, the filters have nothing to do with this new bar chart...

for example a filter is "country" , and in this bar chart i am showing forecast vs sales, independently from country, there is no "country" column in the excel, and still, if i select a random country as a filter, the information shown in the grpah dissapears

[justISO]

in your bar-chart try to modify your measures to make them ignore 'filters' by adding so called set analysis part {1}, so your measure should look something like this:

sum({1} your_field)

Now Qlik starts to filter 'country' in your barchart, but as your table is not connected with other tables it just cuts off data as I was guessing before. This how Qlik works and does not matter that you are filtering not related dimensions.

[Manuel174102]

hello thanks for answering.

the problem is not really there, because I do not really need a formulas.

My excel already shows the numbers than I want to show in my graph.  

I will upload my excel so u see it, and you can see the diagram i am trying to build with qlik sense.

the numbers dont really make sense, i have just made them up haha

[justISO]

Ok, then can you confirm, that in 'Data model viewer' your loaded table for this graph is really not connected with any other table? If there are no relation like circled below:

, can you specify how does 'the information in the bar chart goes away and it only shows an empty diagram' looks like in your case? Does you see Year-Month, but not see bars? Or is there only error message?

[Manuel174102]

Hello,

For some reason they are connected. I do not want them to be connected. Maybe thats why. How can I delete this connection?

It shows the following:

[justISO]

Relation appears between 2 fields with the same name. So you need to rename 1 field in 1 of related tables. In load script this can be done like this:

Your_field_name as Your_new_name,

[Manuel174102 · Accepted solution]

It worked! You are a hero! haha