Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Making a pricelist where some price is different every month

This is a beginners question I want to make an pricelist in QlikView. This is gonna be used for a sales overview report i am supposed to make.

This excample is a pricelist for Fruits. All fruits have a constant price through the year, but there is one item(FruitBasket) that have different price every month. I have one table called PriceList with fields: "Price" and "Product". When the value in the productfield is fruit basket the pricefield need to get price from another table but im not sure how to do this. I have made the FruitBasketPrice table with fields: "Month" and "Price" table but i don't know how to link them.

0 Replies