topic Re: Something weird happens with my graph. HELP PLEASE in App Development

Something weird happens with my graph. HELP PLEASE

Manuel174102 — Tue, 27 Sep 2022 10:43:16 GMT

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?

Re: Something weird happens with my graph. HELP PLEASE

justISO — Tue, 27 Sep 2022 10:53:05 GMT

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.

Re: Something weird happens with my graph. HELP PLEASE

Manuel174102 — Tue, 27 Sep 2022 10:59:35 GMT

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

Re: Something weird happens with my graph. HELP PLEASE

justISO — Tue, 27 Sep 2022 11:16:32 GMT

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.

Re: Something weird happens with my graph. HELP PLEASE

Manuel174102 — Tue, 27 Sep 2022 12:16:06 GMT

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

Re: Something weird happens with my graph. HELP PLEASE

justISO — Tue, 27 Sep 2022 13:48:15 GMT

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?

Re: Something weird happens with my graph. HELP PLEASE

Manuel174102 — Tue, 27 Sep 2022 13:56:57 GMT

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:

Re: Something weird happens with my graph. HELP PLEASE

justISO — Tue, 27 Sep 2022 14:07:38 GMT

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,

Re: Something weird happens with my graph. HELP PLEASE

Manuel174102 — Tue, 27 Sep 2022 14:09:59 GMT

It worked! You are a hero! haha