Label in Straight Chart

[#1]

Dear Community,

I have a very strange behaviour in one of my QVWs.

I created a line chart containing some sales numbers and when I change the Label of some of my expressions, the associated expression values are changing.

Please find attached two screenshots of the straight chart, where I did not change anything in the expression itself, but only in the label.

As you see I only added a few "1" before the "Menge Artikel" label, but still the values of some of the rows are changing.

Another strange effect is, that the "Expression Total" line always stays the same.

Does anyone know, where this behaviour is coming from?

I'm working on QV 11.2 SR 10

Thank you for your help and if you need more specific information please tell me!

Kind regards,

Tobias

[Gysbert_Wassenaar]

Can you post a small qlikview document that demonstrates this behavior?

[rwunderlich]

Does you expression refer to the label name? Can you post your expression?

-Rob

[#4]

Hi Gysbert and Rob,

thank you for your replies.

@Gysbert: The QVW where this phenomenon happened is about 1,2 GB in size. I tried to shrink the data model down to the point where I have all needed information to provide you with the specific straight table, but after I did that (the QVW is now about 2,5 MB in size) the phenomenon disappeared. Could it be, that it happens because the application is too big?

@Rob: No my expression does not refer to the labelname. It's a simple string I entered in the label field of the expression. The expression itself is the following:

SUM(AGGR(AVG({$<RelatedProducts_Orderdatenum={$(=CONCAT(DISTINCT NummerDatum_Kalender_VKBelege-2, ','))}>}RelatedProducts_Menge_Hauptprodukt), RelatedProducts_Variante_Hauptprodukt, RelatedProducts_Ordernumber))

Basically it does the following: It calculates the quantity of products that were purchased in the same order. (So to say these products were in the same shopping basket). The field "RelatedProducts_Variante_Hauptprodukt" is in the AGGR() statement, because it can happen that products with the same ordernumber are placed in the shopping basket twice and they are taken from different places in the warehouse. The set expression only connects this expression to another date range.

All in all the expression is pretty straight forward and as I wrote above the phenomenon is not happening in my shrinked file.

I will try to rebuild this error in a smaller qvw and if I'm able to I will post it here.

Kind regards and thank you for your help,

Tobias

[Gysbert_Wassenaar]

Perhaps you were just unlucky and the chart object suffered some kind of corruption. Perhaps if you replace it with a new one the problem also disappears.