Expression stoped working after upploading updated data in Qliksense
Hi
I'm new but not that new to Qliksense.
I had an app where i created an expresseion that say if a product named xxx then i want an average on year xx.
This expression worked for me before i upploaded updated data. if i separate them and you just "IF" it will work with the first part and when i create an expression that will show me the Average it also workes. but it doesnt work together for some reason.
here is my expression.
=if([uträkning av marginal.Produkt namn]='Varubrev 1:a klass sändning', Avg({<[uträkning av marginal.År]={'2019'}>}[Snittvikt (g)]))
I have controlled if the produkt name is the problem but it is not it, i have controlled it maybe 10 times but it is not.
As i meantioned above i have tested to just take the if part and then the average part and bothe worked but separatly. they just don't want to work together.
the system is telling me the expression/frmula is OK but the result it showes me is just "-".
When i uploaded the new data i upploaded many tabels and and that is why the produkt name has a table name to look att but before i upploaded the new data it only had one table
in one of the print screens, you can see to the left that i have used the "Average" part of the expression and it worked. And i have also used the IF expression without the Average part abut with only numbers such as "19,5" and it worked.
i have been trying to fix this for about 3 hour and tried everything but just can't. it feels like there is a bug in the system.
