Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP
MVP

Re: Script Problem

Then take Food_Price_substitute as third dimension.

5 Replies
Not applicable

Re: Script Problem

anyone?

MVP
MVP

Re: Script Problem

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

Re: Script Problem

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?

MVP
MVP

Re: Script Problem

Then take Food_Price_substitute as third dimension.

Not applicable

Re: Script Problem

This is it, just perfect tresesco.

Thank you, ALOT!

Community Browser