Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script Problem

Guys,

I have this script with two lines almost equal, except for their prices, and I am getting no values due to the same names, I believe. I want both to be shown in my chart "Food Price" (Third blue box in the script).

Can you guys script a way our of this problem for me please?

Thank you,

There it is the two files

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Then take Food_Price_substitute as third dimension.

View solution in original post

5 Replies
Not applicable
Author

anyone?

tresesco
MVP
MVP

It seems that your Food_Price_substitute has multiple values for those intersections where you are gettinh a null/'-'. You should try expression like: = Sum(Food_Price_substitute ).


Not applicable
Author

That's not exactly what i would like to have... I would like to see two times, one written fish with cost 10, and another one with fish costing 7. Using Sum(Food_Price_substitute ) it shows only one time fish with the cost 17...

Is there a way to solve that?

tresesco
MVP
MVP

Then take Food_Price_substitute as third dimension.

Not applicable
Author

This is it, just perfect tresesco.

Thank you, ALOT!